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

Content with tag Date Manipulation Rss

   Items 1 to 20 of 89    Older >>
 

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,141 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 | 14,842 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,796 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 | 38,183 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 | 863 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 | 6,913 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 | 14,888 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 | 17,923 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 | 17,925 reads

Date add with Different DataType

By Paresh Patel 2013/06/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,393 reads

DATETIME - 4

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

Precision required

By David Bridge 2013/03/14 | Category: rounding
Rating: (not yet rated) |  Discuss |   Briefcase | 1,811 reads

INNER JOIN

By Kapil Singh 2013/03/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,189 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,477 reads

SQL Server 2012: Time Marches On

Greg Larsen explores the new SQL Server 2012 date and time functions and shows you how to exploit these functions in new application code.  Read more...
By Additional Articles 2013/02/13 | Category: date manipulation
Rating: (not yet rated)  Rate this |   Briefcase | 3,150 reads

Date Difference

By Siddharth Tandon 2013/02/04 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,216 reads

EOMONTH - 1

By bitbucket-25253 2013/01/21 | Category: emonth
Rating: (not yet rated) |  Discuss |   Briefcase | 2,239 reads

Finding New Years Eve

By Steve Jones 2013/01/01 | Category: humor
Rating: (not yet rated) |  Discuss |   Briefcase | 2,572 reads

Datetime Default

By malls reddy 2012/11/27 | Category: date manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 2,105 reads

Nanoseconds

By Tom Thomson 2012/11/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,474 reads
   Items 1 to 20 of 89    Older >>
 
Tags
t-sql (56)    
datetime (7)    
sql spackle (3)    
blogs (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)    
case (1)    
convert (1)    
cte (1)    
data types (1)    
datatype (1)    
date (1)    
date data types (1)    
dateadd (1)    
dates (1)    
datetimeoffset (1)    
dimensions (1)    
emonth (1)    
fall on friday (1)    
formatting (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)    
sql server 2012 (1)    
sql server 7 (1)    
stored procedures (1)    
week days (1)