Re: Milliseconds
From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 12 Sep 2001 10:37:51 -0700
Message-ID: <9no6hf02lq5_at_drn.newsguy.com>
Date: 12 Sep 2001 10:37:51 -0700
Message-ID: <9no6hf02lq5_at_drn.newsguy.com>
In article <3b9f1eac_at_cpns1.saic.com>, "Allan says...
>
>Hi,
>Does anyone know how to pick up milliseconds in pl/sql.
>I get seconds using the TO_DATE(sysdate, 'format') function, but I really
>need to pick up the milliseconds too.
>
>
>Thanks in advance,
>Allan Martin
>
>
In 9i, the TIMESTAMP type includes this. Prior to that, see:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:341817437103
for how to use either a java stored procedure or a C external procedure to get this.
-- Thomas Kyte (tkyte_at_us.oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Wed Sep 12 2001 - 19:37:51 CEST