Re: DateTime Question

From: Terry Steyaert <steyaert_at_my-deja.com>
Date: 2000/06/14
Message-ID: <8i8g35$6t8$1@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 CDT