Home » SQL & PL/SQL » SQL & PL/SQL » convert From week to date
convert From week to date [message #195474] Thu, 28 September 2006 21:30 Go to next message
triluu
Messages: 12
Registered: September 2006
Junior Member

Hi!
Can you help me! I need convert From week in the year to monday of the week.
Thanks.
Re: convert From week to date [message #195499 is a reply to message #195474] Fri, 29 September 2006 01:39 Go to previous messageGo to next message
sandeepk7
Messages: 137
Registered: September 2006
Senior Member

Try this query..

select decode(to_Char(to_date('01-JAN-'||&Cur_year),'DY'),'MON',
to_date('01-JAN-'||&Cur_year),next_day(to_date('01-JAN-'||&Cur_year),'MON'))+(7*(&cur_week-1)) from dual


Value of Cur_year may be any year and Cur_week must be between 1-52.


Sandy

[Updated on: Fri, 29 September 2006 02:25]

Report message to a moderator

icon12.gif  Re: convert From week to date [message #195724 is a reply to message #195499] Sun, 01 October 2006 20:57 Go to previous message
triluu
Messages: 12
Registered: September 2006
Junior Member

Thank You !
Previous Topic: SUM OVER
Next Topic: unlock table in oracle 8i sqlplus urgent
Goto Forum:
  


Current Time: Tue Dec 06 16:00:11 CST 2016

Total time taken to generate the page: 0.14155 seconds