date format problem on different machine

[learning_bee]

the users enter 5/20/2004 from the application, the database stored as May 20, 20004. When he queries the data retrieved as 20/5/2004. but when I queries, it display as 5/20/2004


any thought about the inconsistent between these machine??

[rotem_fo]

NLS_DATE_FORMAT environment variable ?!

[learning_bee]

from the database server:

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8ISO8859P1
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 9.2.0.1.0


on Oracle client, we use WE8ISO8859P1 and date format dd-mon-yyyy, all across so what reason for this inconsistent display????

thanks all

[JMac]

5/20/2004 from the application

What are you using for the query? Is it the application? This may well pick up the date format from the OS. If its Windows look at your regional date time settings - the application may use these to display dates.

If it's SQL*Plus then check the NLS settings as outlined above.

[zainalj]

Check your NLS_DATE_FORMAT. It always take from machine where you login.