Re: date format precision sub second

From: Dmitry <support_at_ispirer.com>
Date: Mon, 25 Nov 2002 19:44:56 +0200
Message-ID: <artneg$m1kv1$1@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:44:56 CST