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 favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts 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 | 967 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,264 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 | 759 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,502 reads
   Items 1 to 4 of 4