Difference between two dates in weeks

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

hayden-508426 SSC Rookie Points: 34 More actions · Answer 1

Couldn't you just use the following?

SELECT DATEDIFF(wk,@StartDate,@EndDate)

Pat Reiter Old Hand Points: 378 More actions · Answer 2

I don't think that datediff(wk) salutes @@DateFirst.

[font="Courier New"]DateFirst StartDate EndDate DateDiff WeekDiff

--------- ----------- ----------- ----------- -----------

7 Sun 25May08 Mon 26May08 0 0

7 Mon 19May08 Sun 01Jun08 2 2

7 Sat 24May08 Sun 25May08 1 1

DateFirst StartDate EndDate DateDiff WeekDiff

--------- ----------- ----------- ----------- -----------

1 Sun 25May08 Mon 26May08 0 1

1 Mon 19May08 Sun 01Jun08 2 1

1 Sat 24May08 Sun 25May08 1 0

[/font]

Pat Reiter Old Hand Points: 378 More actions · Answer 3

Says here that DATEDIFF doesn't consider DATEFIRST.

Cookies on SQLServerCentral