SQLServerCentral.com Scripts tagged Date

Date Format

Mon, 11 Mar 2013 06:00:00 UT

Returns your date in the format mask you require.

Calculate U.S. Holidays

Fri, 01 Jul 2011 06:00:00 UT

This script runs off the Date Calendar table to flag is_workday when your business is closed for holiday.

Convert seconds to a timestring

Wed, 05 May 2010 06:00:00 UT

This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'

Date Calendar

Wed, 21 Jul 2010 06:00:00 UT

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.

Return X Day of Month

Tue, 03 Mar 2009 07:00:00 UT

This function will return the first, second, third, fourth or last day of a given month.

Function to Return Date and Time String for File Archiving

Wed, 18 Feb 2009 07:00:00 UT

This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.