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:16 pm

    #1594720

    dhananjay.nagarkar (3/7/2013)

    Hi Lynn,

    that will not help since in my case one of the dates can remian NULL hence if that's the case then it will not work using > , = etc; hence datediff

    thanks

    Dhananjay

    If either if the date values is NULL, then it will fail the test either way, with or without DATEDIFF.

    You need to explain what you want to happen if one or both of the values is NULL.