Re: Using date format in Oracle??

From: Ron Reidy <rreidy_at_ecentral.com>
Date: 1997/06/15
Message-ID: <33A3F9AC.A25CC5FC@ecentral.com>#1/1

greg teets wrote:

> I am confused about the date format in Oracle. Can a record use a
> date column directly or do you have to use the TO_Date function?
>
> If it can be added directly, what is the format? All my date fields
> error out because of bad format.
>
> Thanks

Greg,

What is the format of your date variable? The default is 'DD-MON-YY'. If your format is of some other type (e.g. 'MM/DD/YY', etc.), you will need to use the TO_DATE function to express the conversion pattern (e.g. TO_DATE(:var,'MM/DD/YY')). This is documented in the SQL*Plus User's Guide.

Hope this helps.

rr Received on Sun Jun 15 1997 - 00:00:00 CDT