Re: how to store time with milliseconds in Oracle ?

From: Alton Ayers <altona_at_ditw.com>
Date: Fri, 10 Jul 1998 16:00:22 -0400
Message-ID: <35A672D6.53EC6BDB@ditw.com>

The .SSSSS in the mask actually returns the number of seconds since midnight, not hundred(?) thousandths as you would think.

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:00:22 CDT