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!

Converting Date to Day of week

627574Jun 23 2008 — edited Jun 23 2008
I have to convert data from one of my date columns to Day of week numbers.
i.e., if date is 23-Jun-2008, I have to convert it to 2 as it is Monday.
I can use 'decode' to convert 'Monday' to 2 and so on.
But how can I convert 23-Jun-2008 to 'Monday'.
In my table I am having records created in 2007.

Thanks & Regards
Raghu
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2008
Added on Jun 23 2008
10 comments
35,302 views