<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>
Content with tag
Date
Items 1 to 9 of 9
Date Format
Returns your date in the format mask you require.
Read more...
By
Ervin Santiago
2013/03/11
|
Source:
SQLServerCentral.com
|
Category:
date
Rating:
|
Discuss
|
Briefcase
|
1,430 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
Calculate U.S. Holidays
This script runs off the Date Calendar table to flag is_workday when your business is closed for holiday.
Read more...
By
Boyd Tyrrell
2011/07/01
|
Source:
SQLServerCentral.com
|
Category:
holiday
Rating:
|
Discuss
|
Briefcase
|
2,341 reads
Date Calendar
Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.
Read more...
By
Sean Smith
2010/07/21
|
Source:
SQLServerCentral.com
|
Category:
date
Rating:
|
Discuss
|
Briefcase
|
5,180 reads
Calculate U.S. Holidays
This script runs off the Date Calendar table to flag is_workday when your business is closed for holiday.
Read more...
By
Boyd Tyrrell
2011/07/01
|
Source:
SQLServerCentral.com
|
Category:
holiday
Rating:
|
Discuss
|
Briefcase
|
2,341 reads
Convert seconds to a timestring
This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'
Read more...
By
Wilfred van Dijk
2010/05/05
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,255 reads
Date Calendar
Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.
Read more...
By
Sean Smith
2010/07/21
|
Source:
SQLServerCentral.com
|
Category:
date
Rating:
|
Discuss
|
Briefcase
|
5,180 reads
Return X Day of Month
This function will return the first, second, third, fourth or last day of a given month.
Read more...
By
Justin Wagner
2009/03/03
|
Source:
SQLServerCentral.com
|
Category:
date
Rating:
|
Discuss
|
Briefcase
|
1,075 reads
Function to Return Date and Time String for File Archiving
This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.
Read more...
By
Joshua A. Walker
2009/02/18
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,352 reads
Items 1 to 9 of 9
Tags
function
(3)
calendar
(2)
time
(2)
t-sql
(2)
archive file
(1)
archiving
(1)
calculate
(1)
complex
(1)
convert
(1)
date manipulation
(1)
dba
(1)
format
(1)
holiday
(1)
miscellaneous
(1)
modulus
(1)
parameterization
(1)
populate
(1)
reference
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
