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 - 00:29:36 CDT
