Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Date Manipulation Rss

   Items 1 to 20 of 99    Older >>
 

Calculate Age (in years)

An inline table valued function (iTVF) that can be used to calculate age in years.  Read more...
By Alan Burstein 2016/04/27 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 670 reads

Finding the quarter

By Steve Jones 2016/02/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,467 reads

Calendar Table Function

This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently  Read more...
By Chris Kutsch 2016/01/25 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 3,900 reads

It's the end of the year

By Steve Jones 2015/12/31 | Category: date manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,639 reads

Job Schedules

By Steve Jones 2015/11/10 | Category: sql agent
Rating: (not yet rated) |  Discuss |   Briefcase | 1,530 reads

DY

By Steve Jones 2015/11/06 | Category: date manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,570 reads

Calendar Table Function

This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently  Read more...
By Chris Kutsch 2016/01/25 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 3,900 reads

The First Day

By Steve Jones 2015/01/01 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,276 reads

Get month days

Gets the number of days in a month  Read more...
By Igor Micev 2014/11/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,241 reads

Calculate gregorian easter sunday using a table valued function

Calculate gregorian easter sunday using a table valued function.  Read more...
By Robin Langell 2014/09/03 | Source: SQLServerCentral.com | Category: easter sunday
Rating: |  Discuss |   Briefcase | 650 reads

The SQL Server 2008 Datetimeoffset Data Type

The Datetimeoffset Data Type was introduced in SQL Server 2008 (and .Net Frameword 3.5) and is the most advanced date and time date type available.  Read more...
By James Skipwith 2014/03/28 (first published: 2011/04/18) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 13,381 reads

Calendar Tables II - The Anchor

Show the results for a date even if there is no data.  Read more...
By Todd Fifield 2014/02/21 (first published: 2010/08/16) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 15,271 reads

DateCeiling Function

Rounds dates up to the nearest datepart.  Read more...
By Gordon Klundt 2014/02/19 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 1,848 reads

Calendar Tables

Learn how to avoid complex date calculations and increase performance using calendar tables in this article from Todd Fifield.  Read more...
By Todd Fifield 2014/02/14 (first published: 2010/07/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 39,590 reads

Convert Months,Days,ShortMonths to different Languages

Convert Months,Days,ShortMonths to Different Langauges with out sql server set language function can be used in views tables and stored procedures also includes proper case conversion  Read more...
By William McLaughlin 2014/02/03 | Source: SQLServerCentral.com | Category: dates
Rating: (not yet rated) |  Discuss |   Briefcase | 944 reads

How to Compare Rows within Partitioned Sets to Find Overlapping Dates

How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates  Read more...
By Kevin Wu 2013/12/25 (first published: 2010/10/11) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 7,039 reads

Group Islands of Contiguous Dates (SQL Spackle)

Fill in another bit of your T-SQL knowledge by learning how to quickly group ranges of contiguous dates without RBAR.  Read more...
By Jeff Moden 2013/10/04 (first published: 2010/12/07) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 16,395 reads

Sorting Months By Number (SQL Spackle)

Fill in another bit of your T-SQL knowledge by learning how to sort a result set by the proper month order, but use the month name instead.  Read more...
By Jeff Moden 2013/08/02 (first published: 2010/11/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,119 reads

Formatting Dates with 3 Character Months (SQL Spackle)

Another in the series of articles to help you "fill in the cracks" in your T-SQL knowledge. MVP Jeff Moden shows us a super simple, high performance method to solve this timeless problem.  Read more...
By Jeff Moden 2013/07/19 (first published: 2011/01/20) | Source: SQLServerCentral.com | Category: formatting
Rating: |  Discuss |   Briefcase | 18,109 reads

Date add with Different DataType

By Paresh Patel 2013/06/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,461 reads
   Items 1 to 20 of 99    Older >>
 
Tags
t-sql (63)    
datetime (7)    
date (3)    
sql spackle (3)    
blogs (2)    
cte (2)    
date conversion (2)    
datediff (2)    
humor (2)    
sql server 2008 (2)    
tally table (2)    
user defined function (udf) (2)    
age (1)    
aggregates (1)    
analysis services (ssas) (1)    
between (1)    
calendar (1)    
case (1)    
convert (1)    
datatype (1)    
datatypes (1)    
date data types (1)    
dateadd (1)    
datepart (1)    
dates (1)    
datetimeoffset (1)    
dimensions (1)    
easter sunday (1)    
emonth (1)    
fall on friday (1)    
formatting (1)    
holiday (1)    
inline table valued function (itvf) (1)    
language conversion (1)    
modulus (1)    
months (1)    
msdb (1)    
next 13th (1)    
nth occurance of day in a month/year (1)    
partitioned sets (1)    
proclarity (1)    
recursion (1)    
rounding (1)    
row_number() (1)    
scripts (1)    
set dateformat (1)    
set-based (1)    
sql agent (1)    
sql server 2012 (1)    
sql server 7 (1)    
stored procedures (1)    
table valued function (1)    
week days (1)