Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Strange date problem -- please help !!
Arjan van Bentem wrote in message <36dea76a$0$1366_at_newton>...
>Oracle is too nice to us. When a date does not fit the date format, Oracle
>tries a few other formats and finds that swapping day and month works fine.
>
>Indeed, I don't like it either, so who knows how to disable this feature?
What Oracle product makes this swap? SQL or PL/SQL engine? I can't receive
such result. May be it is your application server or application itself?
Would you
like to give more information about it?
As for source question, try to replace nls_territory in application server
environment,
Application can recognize it and then "AMERICAN" means 'mm.dd.yy' date
format.
Good luck,
Leon Grinberg leon_at_grant.kharkov.ua Received on Tue Mar 09 1999 - 10:14:09 CST
![]() |
![]() |