Re: DateTime Question
Date: 2000/06/14
Message-ID: <8i8g35$6t8$1_at_nnrp1.deja.com>#1/1
It really depends on what you are interested in. You could just do a
'31-JAN-00' as that's the default format for a date string. (From everything I have seen on Unix systems. Your results may vary.)
If you want a date and time, you can format it your own way, in whichever format you want. Basically, you have:
YY - Two digit year
YYYY - Four digit year
MM - Month
DD - Day of month
HH24 - Hours in 24 hour time. You can do 12 hour time, but I don't
know how to do AM/PM.
MI - Minutes
SS - Seconds
You just put your format as how ever you wish to set it. To receive, you use a TO_CHAR, with the column name and then the format.
Terry Steyaert
steyaert_at_my-deja.com
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Jun 14 2000 - 00:00:00 CEST