<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>
Scripts with tag
Date Manipulation
Search for
any
content tagged
date manipulation
Add a script
Items 1 to 20 of 22
Next 20 >>
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,251 reads
UDF_GET_NEXT_WEEKDAY
A simple way of getting the next weekday's dates...
Read more...
By
Praveen Kumar Peddi
2012/01/30
|
Source:
SQLServerCentral.com
|
Category:
date manipulation
Rating:
|
Discuss
|
Briefcase
|
797 reads
Get next 1st thursday
Function to get the 1st thursday from the given day.
Read more...
By
Harsha Majety
2012/01/20
|
Source:
SQLServerCentral.com
|
Category:
date manipulation
Rating:
|
Discuss
|
Briefcase
|
932 reads
Getting Age in Text or Date Difference in text format
This function returns the difference between the date in text format
Read more...
By
Anand Uchagawkar
2011/09/01
|
Source:
SQLServerCentral.com
|
Category:
age
Rating:
|
Discuss
|
Briefcase
|
942 reads
Holiday List
A table UDF to return a list of holidays for a given year.
Read more...
By
Joe Booth
2011/06/22
|
Source:
SQLServerCentral.com
|
Category:
date manipulation
Rating:
|
Discuss
|
Briefcase
|
1,490 reads
Find Last Day of the Month
Find the last day (or number of days in a month) in one statement without having to use IFs or BUTs.
Read more...
By
Mariana Maas
2011/05/10
|
Source:
SQLServerCentral.com
|
Category:
date manipulation
Rating:
|
Discuss
|
Briefcase
|
2,235 reads
Method to get the month name of a given date
Easy way to get the month name of a date
Read more...
By
Subbu Ram
2011/05/06
|
Source:
SQLServerCentral.com
|
Category:
date manipulation
Rating:
|
Discuss
|
Briefcase
|
1,459 reads
Function to get number of days in month
Function to get number of days in month
Read more...
By
Harsha Majety
2011/04/27
|
Source:
SQLServerCentral.com
|
Category:
date manipulation
Rating:
|
Discuss
|
Briefcase
|
2,458 reads
Previous Business Day
This SQL Server UDF returns the previous business day.
Read more...
By
Arsen Serobian
2010/11/22
|
Source:
SQLServerCentral.com
|
Category:
date manipulation
Rating:
|
Discuss
|
Briefcase
|
1,170 reads
UDF_GetGMTOffset
Calculates the offset between the UTC time and the SQL Server's local time.
Read more...
By
Alex M
2010/11/26
|
Source:
SQLServerCentral.com
|
Category:
date manipulation
Rating:
|
Discuss
|
Briefcase
|
521 reads
DateCeiling Function
Rounds dates up to the nearest datepart.
Read more...
By
Gordon Klundt
2010/11/29
|
Source:
SQLServerCentral.com
|
Category:
date manipulation
Rating:
|
Discuss
|
Briefcase
|
969 reads
DateFloor Function
Rounds dates down to the nearest datepart.
Read more...
By
Gordon Klundt
2010/11/17
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,057 reads
A Flexible Day Of Week Function
A Flexible Day Of Week Function where a criteria can be passed as an integer to a stored procedure.
Read more...
By
Todd Young
2010/10/13
|
Source:
SQLServerCentral.com
|
Category:
date manipulation
Rating:
|
Discuss
|
Briefcase
|
1,262 reads
Pass in Year and Quarter and get the fiscal start and end dates
Pass Year and Quarter and get the Fiscal StartDate and Endate. Example: pass 2099-Q1 will yield the following results 2009-10-01 2009-12-31
Read more...
By
Sriman Bapatla
2010/09/27
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
937 reads
Slow SP with date parameters solved.
when you use datetime parameters in SPs in the where clause the SP becomes very slow
Read more...
By
Virgilio Licovali Bustos Ramirez
2010/04/28
|
Source:
SQLServerCentral.com
|
Category:
stored procedures
Rating:
|
Discuss
|
Briefcase
|
2,750 reads
datetime precision
Accuracy and precision go hand-in-hand. This script helps trim date values to whatever size is stored in a table's column.
Read more...
By
William Talada
2010/01/20
|
Source:
SQLServerCentral.com
|
Category:
datetime
Rating:
|
Discuss
|
Briefcase
|
1,057 reads
t-sql first last day date of the month
Returns the First or last day date of the month for a given date.
Read more...
By
Bernabe Diaz
2009/12/01
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,636 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,011 reads
When will the next 13th fall on a Friday?
This example demonstrates how to use small part of complicated query structure.
Read more...
By
Ashka Modi
2009/08/27
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
621 reads
Nth occurence of a day in a month/year
This article gives a function which return a date based on its occurance as day for a particular month/year.
Read more...
By
Biplov Dan
2009/08/21
|
Source:
SQLServerCentral.com
|
Category:
date manipulation
Rating:
|
Discuss
|
Briefcase
|
652 reads
Items 1 to 20 of 22
Next 20 >>
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
