Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How is date storeed in column?
Randy, thanks for your help...
What I need to know though, is how can I retrieve the time value of a date
entered into the database?
ie: A user makes an entry, I want to track the time it was placed.
Currently it's entering SYSDATE in that field, but when I do a select, it
shows only DD-MON-YY. Does it store the time as well? IF so, how can I
retrieve it, if not, how can I do so?
Thanks!
"Randy DeWoolfson" <randy_at_euclidsys.com> wrote in message
news:395B5EE4.DFCC375D_at_euclidsys.com...
> use the TO_DATE function
> e.g.
>
> TO_DATE('dd-mon-yy hh24:mi:ss', '01-Mar-67 14:35:22')
>
> (Notice minutes are mi not mm )
>
> randy
>
> Beginner wrote:
>
> > When a field is declared as a 'date' type, what format is it? Can it be
> > stored as 'dd-mon-yy hh:mm:ss am'?
> > I have a date field that says too many precision specifiers when I
truncate
> > it this way...Do I have to store this as a string?
>
Received on Thu Jun 29 2000 - 00:00:00 CDT