• 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]