Skip to Main Content
Forums

SQL & PL/SQL

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!

to_char(sysdate,'D','NLS_DATE_LANGUAGE = AMERICAN')

ZaboJun 3 2013 — edited Jun 3 2013
Hello,

I don't understand why, when I execute the following select under SQL/PLUS (SQL*Plus: Release 11.2.0.3.0) or Toad I don't get the same anwser.

select to_char(sysdate,'D','NLS_DATE_LANGUAGE = AMERICAN') from dual;

I thought that setting the language would give me the good answer.

Can anybody help me ?

Edited by: Zabo on Jun 3, 2013 7:07 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2013
Added on Jun 3 2013
3 comments
2,379 views