Re: Milliseconds

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@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 Corp