<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
Search for
any
content tagged
date
Add a script
Items 1 to 6 of 6
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,429 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 6 of 6
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
