Re: year 2000 - Maybe a stupid question

I apologize for my previous post.

Sort on date type does work if nls_date_format is set to any valid date format other than the standard date format.

I had some other problem when I used alter session set nls_date_format='dd-MON-yyyy hh24:mi:ss'; I cannot recall or reproduce what it was but had to do something with sort and possibly using to_char, to_date.

Sorry if I mislead anyone.

Regards !!!

suresh.bhat_at_mitchell-energy.com

Rolf Hauck <Rolf.Hauck_at_datenrevision.de> wrote in article <35B578C0.75D3EF31_at_datenrevision.de>...
> Hi,
> the magic word you need is NLS_DATE_FORMAT. If you set this to the
> format you prefer (try 'dd.mm.yyyy hh24:mi:ss'), you don't need those
> ugly to_date/to_char functions.
> You can set NLS_DATE_FORMAT in your Windows Registry for client access,
> and even in your init.ora. For sqlplus on unix try creating a file
> login.sql in your home-dir, containing "Alter Session set
> NLS_DATE_FORMAT...".
>
> Rolf
>
> Birgit Merschmann wrote:
> >
> > Hi,
> > ...
> > I can't insert a date with 4 characters; for example:
> > 01.01. 2000.
>
Received on Wed Jul 22 1998 - 12:21:46 CDT