Home Forums SQL Server 7,2000 Administration SQL Year and Week numbers RE: SQL Year and Week numbers

  • May 14, 2008 at 7:53 pm

    #815593

    asbains8 (5/14/2008)

    Hi does anyone know how to create a query in SQL 2000 or 2005 to get the year and week number together for a date i.e. the 01/01/2008 would be 200801. I know how to get them seperately using datepart but i need them joined together.

    Any help would be much appreciated.

    Is this what you want??

    select convert(char(4),datename(yyyy,'01/01/2008'))+convert(char(2),datepart (wk,'01/01/2008'))

    --=OR=--

    select convert(char(4),'01/01/2008',112)+convert(char(2),datepart(wk,'01/01/2008'))

    "-=Still Learning=-"

    Lester Policarpio