Datediff calculation

Last Post 11 Oct 2007 08:42 PM by SwePeso. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
rpitiyar
New Member
New Member

--
09 Oct 2007 03: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 08:42 PM
See this article to understand DATEDIFF
http://www.sqlteam.com/article/date...emystified
You are not authorized to post a reply.

Acceptable Use Policy