<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Articles with tag
Date Manipulation
Search for
any
content tagged
date manipulation
Items 1 to 20 of 33
Next 20 >>
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
|
2,921 reads
SQL Server Function to return a range of dates
A quick solution is a table function that will create a date range based on the parameters given. Then, you can just join to the results.
Read more...
By
Additional Articles
2012/11/02
|
Source:
MSSQLTips.com
|
Category:
date manipulation
Rating:
Rate this
|
Briefcase
|
4,068 reads
Dealing with custom date formats in T-SQL
Should I be formatting dates on the database side? What tools can I use in SQL Server to format and parse dates? This article helps you decide which one best suits your needs.
Read more...
By
Gianluca Sartori
2012/03/23
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
7,622 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
2012/02/24 (first published: 2010/07/15)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
24,458 reads
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,080 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,729 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,504 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,412 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
2011/04/18
|
Source:
SQLServerCentral.com
|
Category:
sql server 2008
Rating:
|
Discuss
|
Briefcase
|
8,096 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
2011/01/20
|
Source:
SQLServerCentral.com
|
Category:
formatting
Rating:
|
Discuss
|
Briefcase
|
10,541 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
2010/12/07
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
9,218 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
2010/11/15
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
10,509 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
|
26,800 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
2010/10/11
|
Source:
SQLServerCentral.com
|
Category:
cte
Rating:
|
Discuss
|
Briefcase
|
5,152 reads
Calendar Tables II - The Anchor
Show the results for a date even if there is no data.
Read more...
By
Todd Fifield
2010/08/16
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
8,442 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
|
9,898 reads
Tally Table Uses - Part I
In the first part of a series on Tally Tables, Stefan Krzywick shows how a Tally Table has helped out with fiscal year calculations.
Read more...
By
Stefan Krzywicki
2010/08/02
|
Source:
SQLServerCentral.com
|
Category:
tally table
Rating:
|
Discuss
|
Briefcase
|
13,616 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
2012/02/24 (first published: 2010/07/15)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
24,458 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
|
4,754 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
|
16,798 reads
Items 1 to 20 of 33
Next 20 >>
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
