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 2:57 pm

    #1594711

    dhananjay.nagarkar (3/7/2013)

    I would prefer datediff since that way not dependent of type of date format in DB hence need help please:-)

    If the columns are defined as one of the date data types, you don't need to use DATEDIFF. You can compare dates just like you can compare integers values.