Re: ADO request mistery
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 BortelReceived on Wed Jun 25 2008 - 02:46:34 CDT