Timestamp question?

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:01:05 CEST