Results 1 to 5 of 5

Thread: SQL SERVER DATEPART week problem [Solved]

Threaded View

  1. Jun 22nd, 2005, 03:11 AM #1
    matt3011
    matt3011 is offline

    Thread Starter
    Lively Member matt3011's Avatar
    Join Date
    May 2002
    Location
    France
    Posts
    82

    SQL SERVER DATEPART week problem [Solved]

    I want to do a search based on the week of a given date field.

    I'm using DATEPART(ww,myField) to get that week number but, I don't get the number I want.

    SQL SERVER assumes that the first week begins january 1st.

    Is it possible to change that and make the first week of year to be the first full week ?

    Thanks
    Last edited by matt3011; Jun 22nd, 2005 at 07:45 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width