Datediff not calculating corectly

Question

Post reply

Datediff not calculating corectly

Viewing 7 posts - 16 through 21 (of 21 total)

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

Matt Whitfield SSCrazy Eights Points: 8107 More actions · Answer 1

using convert with a specific style code (112 for example) give unambiguous results.

Atlantis Interactive - SQL Server Tools
My blog[/url]
Why I wrote a sql query analyzer clone

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 2

Lynn Pettis (1/8/2009)
Didn't someone write an article that talked about how DATEDIFF and DATEADD worked? I can't find one on SSC, so it may have been an article on a different site referenced from SSC at one time.

Here it is, Lynn et all 🙂

http://www.sqlteam.com/article/datediff-function-demystified

N 56°04'39.16"
E 12°55'05.25"

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Peso (1/9/2009)
Lynn Pettis (1/8/2009)
Didn't someone write an article that talked about how DATEDIFF and DATEADD worked? I can't find one on SSC, so it may have been an article on a different site referenced from SSC at one time.
Here it is, Lynn et all 🙂
http://www.sqlteam.com/article/datediff-function-demystified

That is exactly the article I was trying to find! Thank you!

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 4

Thank you!

I have that link on my favorites sites collection.

BTW, are yo having a bad hair day? (Just saw your avatar) 😉

N 56°04'39.16"
E 12°55'05.25"

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Peso (1/9/2009)
Thank you!
I have that link on my favorites sites collection.
BTW, are yo having a bad hair day? (Just saw your avatar) 😉

hmmm, no. Several starwars films I saw this past week.

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 6

I was just getting ready to comment on how much Lynn's complexion has improved. 😛 Barry still has to wear his helmet to hide his...

By the way... where'd the OP go? :hehe:

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

scared him off maybe? Hoepfully Peso's link he will follow.