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

Content with tag DateDiff Rss

   Items 1 to 8 of 8   
 

Cursor-Killing: Accessing Data in the Next Row

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.  Read more...
By Edward Pollack 2014/05/27 | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 11,728 reads

Work around for calculating age using the SQL Server DateDiff function

Have you ever wanted to compute age, but the results from the DATEDIFF function seemed to be wrong some of the time? This tip covers why the DATEDIFF function does not always reliably compute age.  Read more...
By Additional Articles 2012/05/23 | Source: MSSQLTips.com | Category: datediff
Rating:  Rate this |   Briefcase | 4,295 reads

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,266 reads

Date Manipulation with DATEADD/DATEDIFF

Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.  Read more...
By Seth Phelabaum 2010/04/07 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 17,307 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,266 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,503 reads
   Items 1 to 8 of 8   
 
Tags
date manipulation (2)    
t-sql (2)    
age (1)    
business days (1)    
business time (1)    
cte (1)    
cursor (1)    
dateadd (1)    
datetime (1)    
getdate() (1)    
lag (1)    
lead (1)    
timeliness (1)    
window function (1)    
work days (1)