Re: Oracle Date query

I believe the date parameter in the db init file only affects the default date format:

For example,

update foo set date_column = TO_DATE('01-JAN-96');

will work only if the NLS_DATE_FORMAT is set to DD-MON-YY.

The default can be overridden in any Oracle tool by explicitly specifying the date format.

For example:

select to_char(date_column, 'DD-MON-YYYY') from foo;

returns '01-JAN-1996' instead of the default specified by NLS_DATE_FORMAT.

Hope this helps,

Blair Wheadon

>
>DD-MON-RR does not work from Oracle Forms.
>
>In reply to the original question, you can set the default date format to
>just about anything you please by editing the NLS_DATE_FORMAT parameter in
>your database initialisation file.
>
>> >
>> > Hi
>> >
>> > I would like to know if Oracle date datatype is able to support the
 year
>> > 2000 and beyond.
>> >
>> > As the date format is of DD-MON-YY, i think it would be impossible
 unless
>> > we are able to increase the Year to YYYY. Is there a way in Oracle to
>> > change the present data format to DD-MON-YYYY??
>> >
>> > TIA...8-)
>> >
>> > regards.
Received on Tue Dec 24 1996 - 00:00:00 CET