SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Date Rss

   Items 1 to 4 of 4   
 

Avoiding Unexpected Results with DATEDIFF in Year Comparisons

Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.  Read more...
By David Strack 2018/04/09 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,320 reads

Binary Date Conversions

By J. Drew Allen 2017/11/20 | Category: date
Rating: (not yet rated) |  Discuss |   Briefcase | 596 reads

Need the First Tuesday Beyond Y days after X Date

A task was set before our team to find the first Tuesday after 10 days from a specific date. This article shows how we accomplished that.  Read more...
By Charles Martin 2011/10/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,521 reads

Convert seconds to a timestring

This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'  Read more...
By Wilfred van Dijk 2010/05/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,390 reads
   Items 1 to 4 of 4   
 
Tags
binary (1)    
cast and convert (1)    
convert (1)    
date manipulation (1)    
datediff (1)    
modulus (1)    
sql server (1)    
time (1)