Tag

#DateDiff

2 blogs

  1. Calculate time in hours and minutes between two dates

    Sounds easy right? I want to calculate the difference in hours and minutes between two dates. A good readable notition for my report. I want a format like this: 00:36:53 OR 02:13:45 This can easy be ...

    SQL Server1 comment9 Oct 2013 · 6.3k reads
    6.3k

  2. Calculate Weeks Between Two Dates using DateDiff

    In SQL Server, there's a buildin function to calculate the number of weeks between two dates. This function is called "DateDiff". The problem with this function is that Sql Server thinks the week ...

    SQL Server1 comment30 Mar 2012 · 50.2k reads
    50.2k
(2 rows affected)sqlblog.nl