Datediff calculation

Last Post 11 Oct 2007 09:42 PM by SwePeso. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
rpitiyar
New Member
New Member

--
09 Oct 2007 04:49 PM
I need to know why this is happening?

if you run
select datediff(hh,'20070730 23:59:59:000','20070801 00:00:00:000') will give you 25
but select datediff(hh,'20070730 23:59:59:000','20070731 23:59:59:000') gives you 24

any known issues?

thx
SwePeso
New Member
New Member

--
11 Oct 2007 09:42 PM
See this article to understand DATEDIFF
http://www.sqlteam.com/article/date...emystified


Acceptable Use Policy
---