OraFAQ Forum: SQL & PL/SQL » convert From week to date

Home » SQL & PL/SQL » SQL & PL/SQL » convert From week to date

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

convert From week to date [message #195474]

Thu, 28 September 2006 21:30

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.

Report message to a moderator

Re: convert From week to date [message #195499 is a reply to message #195474]

Fri, 29 September 2006 01:39

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

Re: convert From week to date [message #195724 is a reply to message #195499]

Sun, 01 October 2006 20:57

triluu
Messages: 12
Registered: September 2006

Junior Member

Thank You !

Report message to a moderator

Previous Topic:	SUM OVER
Next Topic:	unlock table in oracle 8i sqlplus urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 20:36:55 CDT 2024