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

Articles with tag Date Manipulation Rss

Search for any content tagged date manipulation

<< Newer    Items 21 to 40 of 49    Older >>
 

How to get monthly YTD data

This article presents an easy method to get YTD data grouped by months in T-SQL.  Read more...
By Kautuk 2012/01/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 11,341 reads

Using Recursion and Date Tables to Simplify Date Logic

Learn to simplify date logic using date tables and recursion in T-SQL with this article from David Beardsley.  Read more...
By David Beardsley 2011/12/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 9,946 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,517 reads

TIME Gentlemen please! The SQL Server temporal datatypes

If you are still using the old Sybase DateTime datatype, it is a good idea to move your code to the more standard datatypes that were introduced in SQL Server 2008. Joe Celko explains why, and walks through some of the history of the TSQL way of storing and manipulating dates and times.  Read more...
By Additional Articles 2011/05/25 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 3,755 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,421 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,132 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,703 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,144 reads

A Faster BETWEEN Dates

This article shows us a different way of finding all records between 2 dates.  Read more...
By Terry Steadman 2010/11/01 | Source: SQLServerCentral.com | Category: between
Rating: |  Discuss |   Briefcase | 27,462 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,062 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,484 reads

Creating Holidays and Special Dates

A way to save holiday records that can be created as needed into a search-able calendar table.  Read more...
By Terry Steadman 2010/08/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,113 reads

Tally Table Uses - Part I

In the first part of a series on Tally Tables, Sioban Krzywicki shows how a Tally Table has helped out with fiscal year calculations.  Read more...
By Sioban Krzywicki 2010/08/02 | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 15,217 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 | 40,125 reads

Using dates, and times in SQL Server: a workbench approach

In this workbench, Robyn Page provides a gentle introduction to the use of dates in SQL Server. In this new version of her article, it is brought up to date with the newer Datetime features in SQL Server 2005 and 2008.   Read more...
By Additional Articles 2010/05/27 | Source: SimpleTalk | Category: date manipulation
Rating:  Rate this |   Briefcase | 5,510 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: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 17,635 reads

Tally Table - Character Date Validation

Tally (or numbers) tables are one of my favorite query writing tools.  Such a simple premise that can be applied...  Read more...
By Seth Phelabaum 2009/12/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,920 reads

Formatted date in SQL Server 2008

Learn how to get most of the formats required by different countries and applications, using one common date function.  Read more...
By Additional Articles 2009/06/02 | Source: Database Journal | Category: date manipulation
Rating:  Rate this |   Briefcase | 3,645 reads

SQL Server user defined function to convert MSDB integer value to time value

In a recent tip I outlined a process for converting a date, stored as an integer into a datetime data type. Date and time information for run history of SQL Server Agent jobs is stored within the msdb..sysjobshistory table as an integer data type, not as a datetime as one would expect. As promised, this tip picks up where we left off. On converting the integer-typed run_time into a format that is more user friendly for presentation purposes.  Read more...
By Additional Articles 2009/05/20 | Source: MSSQLTips.com | Category: msdb
Rating: (not yet rated)  Rate this |   Briefcase | 2,372 reads

To Date or Not To Date….

OK….so I’m in the middle of a very interesting Effective Dating project…basically we’re dealing with some tables that only store current data, but there is a need for future-dated data as well. Because the base table can’t hold that data...  Read more...
By Sam Bendayan 2009/05/18 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,853 reads
<< Newer    Items 21 to 40 of 49    Older >>