That's unfair!
select
getdate()
, datediff(ss,cast('7/4/2004' as datetime), getdate())%60
------------------------------------------------------ -----------
2004-12-28 16:00:59.590 59
(1 row(s) affected)
Now add 1 and get 0 => No time difference between both date. q.e.d.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]