Re: Timestamps in Oracle

From: David <darussell_at_msn.com>
Date: Sat, 11 Apr 1998 21:21:35 +0100
Message-ID: <OLeQ0dYZ9GA.220@uppubnews03>

The only way to do this is to use a number field as date fields only accept a precision of seconds, Oracle 8 internally introduced dates to a finer granularity, but this has not yet been exposed to the SQL layer, hopefully 8.1??

Regards
David Russell

Norwood Story wrote in message <352E4F98.3466_at_s2systems.com>...
>Does anyone know if there is a way to store a timestamp that contains
>milliseconds? If not has anyone had to deal with this problem
>and what was your solution? My main concern is my Powerbuilder
>front-end that also needs to interface with other RDBMS's.
>
>Thanks in advance!
Received on Sat Apr 11 1998 - 15:21:35 CDT