Re: date mask

From: Ed Prochak <edprochak_at_gmail.com>
Date: 5 Feb 2007 12:20:07 -0800
Message-ID: <1170706807.176317.62230@v33g2000cwv.googlegroups.com>

On Feb 5, 2:54 pm, "kostrikov" <kostri..._at_gmail.com> wrote:
> Hi all,
>
> Can I define a mask for date column?
> I need to input dates in the yyyy-mm-dd format.
>
> thanks

Are you loading data via SQL*Plus (INSERT commands), SQL*Loader (control file option), or custom program (e.g. Pro*C)?

You can specify the conversion format in all three cases. (see the TO_DATE() function).

Ed Received on Mon Feb 05 2007 - 14:20:07 CST