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

Articles with tag DateDiff Rss

Search for any content tagged datediff

   Items 1 to 3 of 3   

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: | Category: cte
Rating: |  Discuss |   Briefcase | 12,106 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: | Category: datediff
Rating:  Rate this |   Briefcase | 4,442 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: | Category: date manipulation
Rating: |  Discuss |   Briefcase | 17,544 reads
   Items 1 to 3 of 3