Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Fractions (of a second) in dates

Re: Fractions (of a second) in dates

From: spencer <spencerp_at_swbell.net>
Date: Tue, 19 Sep 2000 21:04:21 -0500
Message-ID: <KVUx5.172$zv6.81868@nnrp1.sbc.net>

columns defined as DATE are used to represent a point in time, with a resolution down to seconds. In order to represent a finer resolution (for example, milliseconds or any other fraction of a second, you will need to use another datatype.

btw... i believe this information is provided the concepts manual.

"Andy Kent" <andykent.bristol.DontSpamMe_at_virgin.net> wrote in message news:ZzSx5.12679$6T1.195007_at_news2-win.server.ntlworld.com...
> How can I access fractions of a second in a date column in SQL?
>
> -Andy Kent-
>
>
>
Received on Tue Sep 19 2000 - 21:04:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US