Re: Microseconds in Oracle
From: Stephen Markham <smarkham_at_capita.nildram.co.uk>
Date: 1996/07/15
Message-ID: <01bb722e.6a4528c0$640370c3_at_stephenm.capita.nildram.co.uk>#1/1
-
> 1996-07-01-12:07:50:0707
> ^^ ^^ ^^^^
> Four copies of the month!
>
Received on Mon Jul 15 1996 - 00:00:00 CEST
Date: 1996/07/15
Message-ID: <01bb722e.6a4528c0$640370c3_at_stephenm.capita.nildram.co.uk>#1/1
DATE Datatype
The DATE datatype is used to store date and time information. Although date and time information can be represented in both CHAR and NUMBER datatypes, the DATE datatype has special associated properties.
For each DATE value the following information is stored:
· century · year · month · day · hour · minute · second
Minute is represented by MI not MM
Stephen
> Charles Jardine <cj10_at_cam.ac.uk> wrote in article
<31D7B5BE.62EC_at_cam.ac.uk>...
> Debor19071 wrote:
> >
> > Yes!!
> >
> > If you do a TO_CHAR(sysdate, 'yyyy-mm-dd-hh:mm:ss:mmmm') - this
displays
> > down to milliseconds...
> >
> > Deb
>
> Good God!
>
> TO_CHAR(SYSDATE,'YYYY-MM-DD-HH:MM:SS:MMMM')
>
-
> 1996-07-01-12:07:50:0707
> ^^ ^^ ^^^^
> Four copies of the month!
>
Received on Mon Jul 15 1996 - 00:00:00 CEST