Convert DATE to DAY

Dear All,

I need help. I am trying to write a function to convert a date to a day. For example, a datefield like orderduedate converted to Monday or Tuesday or Wednesday etc. instead of 07/11/2005
Any help will be appreciated.

Thanks

to_char(orderduedate,'day') will return sunday,monday etc.

mohanknm,

Thanks alot.