Home Forums SQL Server 2008 T-SQL (SS2K8) Urgent help need to verify DateDiff is correct? RE: Urgent help need to verify DateDiff is correct?

  • March 7, 2013 at 3:25 pm

    #1594725

    observe:

    declare @TestDate datetime;

    select datediff(dd,getdate(),@TestDate)

    select datediff(dd,@TestDate,getdate())

    set @TestDate = '20130318';

    select datediff(dd,getdate(),@TestDate)

    select datediff(dd,@TestDate,getdate())

    -----------

    NULL

    (1 row(s) affected)

    -----------

    NULL

    (1 row(s) affected)

    -----------

    11

    (1 row(s) affected)

    -----------

    -11

    (1 row(s) affected)