Home Forums SQL Server 2008 T-SQL (SS2K8) How do I calculate the week number given a date? RE: How do I calculate the week number given a date?

  • July 19, 2010 at 2:15 am

    #1194746

    Hello,

    Easiest solution is using DATEPART function

    select DATEPART(WEEK,GETDATE())

    If that is not useful for your requirements, you can also think of to create date table in SQL Server

    Eralper
    SQL Server and T-SQL Tutorials and Articles
    Microsoft Certification and Certification Exams