Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag DateDiff Rss

Search for any content tagged datediff

Get your favourite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 4 of 4   
 

Getting Age in Text or Date Difference in text format

This function returns the difference between the date in text format   Read more...
By Anand Uchagawkar 2011/09/01 | Source: SQLServerCentral.com | Category: age
Rating: |  Discuss |   Briefcase | 964 reads

How long has passed since SQL Server service started?

Days, hours and minutes since SQL Server service was started  Read more...
By Lars Søe Mikkelsen 2010/11/05 | Source: SQLServerCentral.com | Category: getdate()
Rating: |  Discuss |   Briefcase | 2,251 reads

Get Business Time

Compare two timestamps and return the difference in either days, hours, minutes or seconds using the 5 workday, 8 hour rule.  Read more...
By Megan Beebe 2008/07/21 | Source: SQLServerCentral.com | Category: datediff
Rating: |  Discuss |   Briefcase | 753 reads

Count Business Days

Using a few constants and a few numeric properties found in two days, calculate the number of workdays between two days.  Read more...
By Megan Beebe 2008/07/18 | Source: SQLServerCentral.com | Category: datediff
Rating: |  Discuss |   Briefcase | 1,485 reads
   Items 1 to 4 of 4