date diff help
in [Programming SQL]
|
Prev: Connection strings going from local drive to a network drive using Wizards in Visual Web Developer?
Next: Set up trace
From: rodchar on 8 Feb 2010 16:32 Hey All, select datediff(wk,'1/10/2010','12/9/2009') This to me should be 6 instead of 5. I've tried the SET DateFirst but they all resolve to 5. Am I looking at this all wrong? thanks, rodchar
From: rodchar on 8 Feb 2010 16:37 scratch this one too. not my day... "rodchar" wrote: > Hey All, > > select datediff(wk,'1/10/2010','12/9/2009') > > This to me should be 6 instead of 5. I've tried the SET DateFirst but they > all resolve to 5. Am I looking at this all wrong? > > thanks, > rodchar
From: sloan on 8 Feb 2010 17:49 How about posting what you found, so future googlers (errr bingers) find a solution and not just a dead-end thread? ... "rodchar" <rodchar(a)discussions.microsoft.com> wrote in message news:0D38C98A-C94C-4339-8B60-368CFEDE02CB(a)microsoft.com... > scratch this one too. not my day... > > "rodchar" wrote: > >> Hey All, >> >> select datediff(wk,'1/10/2010','12/9/2009') >> >> This to me should be 6 instead of 5. I've tried the SET DateFirst but >> they >> all resolve to 5. Am I looking at this all wrong? >> >> thanks, >> rodchar
From: rodchar on 9 Feb 2010 11:41
user error. "sloan" wrote: > How about posting what you found, so future googlers (errr bingers) find a > solution and not just a dead-end thread? > > ... > "rodchar" <rodchar(a)discussions.microsoft.com> wrote in message > news:0D38C98A-C94C-4339-8B60-368CFEDE02CB(a)microsoft.com... > > scratch this one too. not my day... > > > > "rodchar" wrote: > > > >> Hey All, > >> > >> select datediff(wk,'1/10/2010','12/9/2009') > >> > >> This to me should be 6 instead of 5. I've tried the SET DateFirst but > >> they > >> all resolve to 5. Am I looking at this all wrong? > >> > >> thanks, > >> rodchar > > > . > |