Home Forums SQL Server 7,2000 Administration SQL Year and Week numbers RE: SQL Year and Week numbers
rgillings
SSCrazy
Points: 2114
More actions
August 12, 2008 at 6:03 am
#856596
This may be posted already, but...
DECLARE @Date DATETIME
SET @Date = GETDATE()
SELECT CONVERT(VARCHAR,DATEPART(YEAR,@Date)) + CONVERT(VARCHAR,DATEPART(WEEK,@Date))