Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NLS_LANG

OracleGuy777Apr 18 2010 — edited Apr 18 2010
hi,

does setting NLS_LANG on your client also have an effect on date and time?

Say my database is in ENGLISH_UNITED KINGDOM.UTF8, and my client is AMERICAN_AMERICA.UTF8

Now I want to insert the date via sql '01-Jan,2010', which is the UK format. Does this mean that Oracle will look at NLS_LANG, see it is American, think that the first bit is MM and the second bit DD, and therefore do a conversion and try and insert in Jan-01-2010 into a column that is meant to take in 01-Jan-2010? i.e. would the NLS_LANG cause dates to be converted?

thanks
This post has been answered by Hans Forbrich on Apr 18 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 16 2010
Added on Apr 18 2010
#general-database-discussions
6 comments
1,851 views