in
Questions and answers to issues related to Software: Business, Database, Firewalls, Office, Graphics, Security, System, Server. » Database » MS SQL Server » Convert week number and year to date range

Convert week number and year to date range

Hi Experts,

I need a SQL solution to convert week number and year to a start date and end date

Example:

I want to convert

0106

to this
01/01/2006 to 01/07/2006

help!

Kris

Solution: Convert week number and year to date range

Is this what you need,

declare @str varchar(100)
set @str = '0306'
select dateadd( wk , convert( int , substring( @str , 1 , 2 ) ) - 1 ,'01-Jan-2006' ) As StartDate
, dateadd( dd , -1 , dateadd( wk , convert( int , substring( @str , 1 , 2 ) ) ,'01-Jan-2006' ) ) As EndDate

Popular Tags

Browse All Tags