Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Strange date problem -- please help !!

Re: Strange date problem -- please help !!

From: Grinberg L. <leon_at_grant.kharkov.ua>
Date: Tue, 9 Mar 1999 18:14:09 +0200
Message-ID: <7c3hcn$4qa@grant.grant.UUCP>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US