SQLServerCentral.com Scripts tagged TIME

Get daylight savings time

Thu, 26 Aug 2010 06:00:00 UT

After scouring the site, and googling until my fingers bled, I finally put together a function that will return the dates when daylight savings time began/ended since at least 1990.

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'

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.