Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How is date storeed in column?
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