|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
July 24, 2005: On to_char, dates and weekdays
I was born on the 28th of August in 1970. I believe, my parents told me that this date was a Friday. Unfortunately, it's too long ago for me to remember the day myself, but I'd like to verify if this date was indeed a Friday. How would I do that with Oracle?
The select statement returns:
So, indeed, I was born on a friday.
Vielleicht, a german speaking person would like to have the result of the query in german rather than in english. How would she go for that?
Of course, she can alter the
SQL> alter session set nls_language=german; SQL> select to_char(to_date('28.08.1970','dd.mm.yyyy'), 'day') from dual;
In fact, the result is now
Then again, she might not want to alter the nls_language for the session.
SQL> alter session set nls_language=french; SQL> select to_char(to_date('28.08.1970','dd.mm.yyyy'), 'day', 'nls_date_language=german') from dual;
Although the session's language is now french, the result is still in german:
More on Oracle
This is an on Oracle article. The most current articles of this series can be found here.