Re: Timestamp question?

Are you sure you did not mean you are using "9i"? The following datatypes are new for Oracle9i:

TIMESTAMP
TIMESTAMP WITH [LOCAL]TIME ZONE
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
XMLType, native XML datatype
SYS.UriType, SYS.UriFactoryType
SYS.ANYType, SYS.AnyData, SYS.AnyDataSet MDSYS.SDO_GEOMETRY, new spatial datatype

ORDSYS.ORDImage - media type 
ORDSYS.ORDVideo - media type 
ORDSYS.ORDAudio - media type 

If you ARE using 9i, you really should look up the DOC for basic questions like this.

peace_at_japan.com (Peace) 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 - 18:12:52 CEST