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
Printable View
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.