Re: year 2000 - Maybe a stupid question

I don't believe that is the magic bullet !!!

Try to sort on the date type column with the format that you have mentioned below in SQL*Plus.

Most of the time the default works fine. It is only certain situations that you need a different date format.

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 - 11:14:50 CDT