Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 DATEDIFF ( datepart , startdate , enddate )

Author  Topic 

mikebird
Aged Yak Warrior

529 Posts

Posted - 2009-05-13 : 08:36:20

Uhhh

Please explain... I've been doing too much Crystal Reports... too easy

All I want to do is make a comparison between two datetime fields and see which one I should use...

The above function has got me throttled. Not enough SQL these days...

Do I have to break these down? Can't I just ask for the difference between two fields? Same format.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-13 : 08:39:34
See http://www.sqlteam.com/article/datediff-function-demystified


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -