Re: how to store time with milliseconds in Oracle ?

The Oracle date format *always* stores DD:MM:YY:HH:MM:SS.SSSSS - use a format mask to present the data in the format that you want. For example:

SELECT to_char(SYSDATE,'HH:MM:SS.SSSSS') FROM dual;

Hope that helps.

Jeremy

"Alain PIERRE" <Groeps_at_mail.interpac.be> wrote:

>Hi,
>
>I have to store time HH:MM:SS + milliseconds in Oracle.
>Is there an easy way to do this ? No date format seems to support that.
>DATE is 7-byte fixed
>
>Patrick Wtterwulghe
>Oracle DBA
>Groupe-S
Received on Fri Jul 10 1998 - 06:49:25 CDT