SQL Language (MOSC)

MOSC Banner

ORA-01855 AM/A.M. or PM/P.M. required - polish

edited Aug 24, 2012 7:07AM in SQL Language (MOSC) 5 commentsAnswered
Hi,

 

I am experiencing some strange error, that I am not able to fix/find so no option other than post in this forum.

 

Our application support on multiple languages with one oracle code base for all languages.

 

I am experiencing error in Polish environment while running below query.

 

    Select DBUser  From ia_data Where  ia_data."DATEFROM" < TO_DATE ('20120808 12:00:00AM', 'YYYYMMDD HH:MI:SSPM')  Order By Asc

 

- Datatype of  DATEFROM column is "date" and value saved in "YYYY/DD/MM" format

 

- Few NLS_DATABASE_PARAMETERS

 

NLS_LANGUAGE                           AMERICAN

NLS_CURRENCY                           $

NLS_CHARACTERSET                  EE8ISO8859P2

NLS_CALENDAR                           GREGORIAN

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center