Re: Dates for 21st Century?

>
> insert into test_table (ENG_DATE) values ('1-JAN-2001')
> ORA-01830: date format picture ends before converting entire input str
> insert into test_table (ENG_DATE) values ('1-JAN-00')
>

--
Oracle dates default to dd-mon-y, it check your string against this 
format and fails, so you need to do :

insert into test_table(end_date)
values
(to_date('01-jan-2001','dd-mon-yyyy'));

QED ...

Mike
**************************************************************************
Michael Cox          Input Technolgies Ltd
Email                mike_at_kane.demon.co.uk
Compuserve           100045.1715_at_compuserve.com
**************************************************************************