Home Forums SQL Server 2008 SQL Server 2008 - General Detect change of month and year in datestamp RE: Detect change of month and year in datestamp

  • November 26, 2012 at 10:41 am

    #1562312

    Sean Lange (11/26/2012)

    You should look at datepart.

    For example, 2012-04-03 is in the fifteenth week of the year so if that date appears then the week number 15 should appear along side it.

    You sure about that? I believe it is in the 14th week.

    select DATEPART(ww, '2012-04-03')

    Possibly, doesn't really matter what the week number is as long as it is the correct one.