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

Home -> Community -> Usenet -> c.d.o.tools -> How is date storeed in column?

How is date storeed in column?

From: Beginner <NOSPAM_at_hotmail.com>
Date: 2000/06/28
Message-ID: <vpt65.27$Hs3.1402@news1.mts.net>#1/1

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 Wed Jun 28 2000 - 00:00:00 CDT

Original text of this message

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