Re: Timestamp question?

no. 8i only supports to the second. I believe 9i supports to greater precision. If you are using it as a primary key they use a sequence instead.
Jim
"Peace" <peace_at_japan.com> wrote in message news:277abc47.0208041901.45863a0a_at_posting.google.com...
> Hi all,
> I am using Oracle 8i and have this question:
> I have a column with datatype as timestamp and would like to know how
> to view the milli secs stored using sql query. i.e the format to be
> specified in to_Char function ? How ever if I use a program to fetch
> it, the milli secs are retriveable. Also does Oracle 8i support nano
> seconds for timestamp cols?
>
> Thanks for your suggestions,
>
> Cheers,
Received on Mon Aug 05 2002 - 05:31:21 CEST