Re: ADO request mistery

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 25 Jun 2008 09:46:34 +0200
Message-ID: <8c20a$4861f7da$524b5c40$16303@cache2.tilbu1.nb.home.nl>


Wilfrid wrote:

> Sometimes, oracle returns the error message: ORA-01841: (full) year must be
> between -4713 and +9999, and not be 0
> When i check what data the application has sent i can see:
>
> 732531;0;20/06/2008 08:46:58;20/06/2008 08:47:00;title;type;19/06/2008
> 00:00:00;69;349;349;0;0;5;;2;1;20/06/2008 08:46:13;

Where's the year, then?

>
> One of the date is apparently taken as 0 event though the date we send has a
> normal format.

There's no such thing as "normal"; US based systems -as yours- think a date format of MM/DD/YYYY is normal. Europeans know the standard is DD-MM-YYYY. You have a crappy system, that replies in implicit date conversions. Always use explicit conversions: to_date(variable,'Date Format')

-- 

Regards,
Frank van Bortel
Received on Wed Jun 25 2008 - 02:46:34 CDT

Original text of this message