"Andre" <avanrossem_at_hotmail.com> wrote in message
news:4d32d1be.0403290414.1f94c80a_at_posting.google.com...
> Hello all,
>
> I have a problem:
>
> If i put in the following value in an oracle date-field:
> 01-01-29 then oracle converts it to 01-01-2029
>
> But If i insert 01-01-30 then oracle converts it to 01-01-1930
>
> Is this normal? Where can I change it?
>
> regards,
> Anneke
use the to_date function to make sure you translate strings to dates
correctly. eg to_date('01-01-20029','mm-dd-yyyy')
Jim
Received on Mon Mar 29 2004 - 07:25:20 CST
