Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: date format precision sub second
Hi,
Thanks for the promp reply.
unfortunately I use 8i
Thanks
Trev
"Dmitry" <support_at_ispirer.com> wrote in message
news:artneg$m1kv1$1_at_ID-75577.news.dfncis.de...
> Hi,
>
> Oracle 8 has no datatype that allows to save milliseconds as the DATETIME
> datatype in MS SQL Server or microseconds as the TIMESTAMP datatype in IBM
> DB2.
>
> Oracle 9 has the new datatype TIMESTAMP that supports saving fraction of
> seconds.
>
> If you use the Oracle 9i TIMESTAMP datatype you have to use SYSTIMESTAMP
> function instead of SYSDATE.
>
> --
> Best regards, Dmitry
> http://www.ispirer.com/chyfo.html - Database migration software for
Oracle,
> IBM DB2, Microsoft SQL Server, Sybase and MySQL.
>
>
> "Trev" <t.pearce_at_tecsphere.com> wrote in message
> news:artm96$cmm$1$830fa78d_at_news.demon.co.uk...
> > hi,
> > is their a way to get sysdate to be more accurate than seconds i.e
> > milliseconds.
> >
> > trev
> >
> >
>
>
Received on Mon Nov 25 2002 - 11:48:37 CST