Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP! Default date format in SQL*Plus isn't dd-mon-yy!
R wrote:
> Hi!
>
> I'm in a bind here. Doing some schoolwork and for some reason the default
> date format produced by SQL*Plus is not the expected dd-mon-year, but
> YY-MM-DD. I've tried altering the settings in my Date/Time control panel
> with no success.
>
> This wouldn't be a big issue except when I create my tables using the given
> script, the dates are corrupted, since they are in the default format and
> not the expected format.
>
> Can anyone tell me what to enter in Oracle's SQL*Plus client to change the
> default date?
>
> I'm running this on a Windows XP machine with the Oracle 9i personal edition
> installed.
>
> Thanks!
>
>
> P.s. Also getting a comma in place of a decimal point. If there's a quick
> fix for this, I'd appreciate it as well.
>
>
Edit your insert statements using the to_date function and it should
work. Because of the comma have a look at your NLS_LANG variable.
Axel Received on Wed Feb 26 2003 - 04:56:34 CST