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

Content with tags T-SQL, DateTime Rss

   Items 1 to 12 of 12   
 

Finding “Active” Rows for the Previous Month (SQL Spackle)

SQL Server MVP Jeff Moden walks us through the classic problem of finding all the "Active" rows for the previous month using start and end dates. This is excellent for those new to T-SQL.  Read more...
By Jeff Moden 2014/01/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,145 reads

Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

It's an old problem with a solution that's nearly as old. SQL Server MVP Jeff Moden shows us the old trick mixed with a slick trick to format the duration as extended hours, minutes, seconds, and milliseconds.   Read more...
By Jeff Moden 2014/01/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,640 reads

Datetime conversion of empty string

By Gabe Tower 2013/11/25 | Category: datetime
Rating: (not yet rated) |  Discuss |   Briefcase | 2,117 reads

DATETIME - 4

By bitbucket-25253 2013/03/18 | Category: datetime
Rating: (not yet rated) |  Discuss |   Briefcase | 1,959 reads

Converting to datetime a char field with several possible date formats

Converting to datetime a char field having several possible date formats  Read more...
By Federico Iori 2013/02/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,488 reads

DATETIME 2

By bitbucket-25253 2012/08/02 | Category: datetime
Rating: (not yet rated) |  Discuss |   Briefcase | 2,696 reads

TSQL fast unix timestamp conversion

How to convert Unix timestamp into datetime taking into account also summer or winter time  Read more...
By Federico Iori 2011/12/02 | Source: SQLServerCentral.com | Category: timestamp
Rating: |  Discuss |   Briefcase | 447 reads

DateTime Comparison

By jkelly 2011/11/28 | Category: datetime
Rating: (not yet rated) |  Discuss |   Briefcase | 2,672 reads

Use of DATETIME and BETWEEN - Part 2

By Dwayne Dibley 2011/11/18 | Category: datetime
Rating: (not yet rated) |  Discuss |   Briefcase | 2,869 reads

Use of BETWEEN and DATETIME

By Dwayne Dibley 2011/09/27 | Category: datetime
Rating: (not yet rated) |  Discuss |   Briefcase | 2,700 reads

T-SQL

By bitbucket-25253 2009/11/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,520 reads

What were the dates of all the Fridays in this quarter?

This script displays list of all dates of all Fridays of this quarter.  Read more...
By Ashka Modi 2009/08/25 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 1,026 reads
   Items 1 to 12 of 12   
 
Tags
date manipulation (5)    
between (1)    
case (1)    
convert (1)    
converter (1)    
duration (1)    
function (1)    
precision (1)    
sql spackle (1)    
string (1)    
summer time (1)    
timestamp (1)    
unix (1)