Re: how to store time with milliseconds in Oracle ?

Duh - I was wrong. the "SSSSS" is seconds past midnight - thanks (and apologies) to all those pointing out my goofy mistake.

JR

jrinusa_at_gte.net (Jeremy Russell) wrote:

>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 - 15:04:31 CDT