Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag TIME Rss

   Items 1 to 6 of 6   

Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

When you build applications that store data in SQL Server you will most likely have to store dates and times, and you’ll call functions to do date manipulations. It is important to understand the different date and time data types, and when to use one data type over another. In this level I will be exploring the different date and time data types and discussing when each type is appropriate.  Read more...
By Gregory Larsen 2015/11/25 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,701 reads

Data Mining Introduction Part 6: Time series algorithm

This article is part of the Data Mining introduction series. This article is about time series.   Read more...
By Daniel Calbimonte 2013/08/06 | Source: | Category: data
Rating: |  Discuss |   Briefcase | 7,292 reads

How Long Backups Will Take

When you are running a backup or a restore, this script gives you an estimate of completion time.  Read more...
By Miguel Quintana 2013/06/14 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 1,495 reads

Get daylight savings time

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.  Read more...
By Langston Montgomery 2010/08/26 | Source: | Category: function
Rating: |  Discuss |   Briefcase | 1,671 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,385 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: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 1,407 reads
   Items 1 to 6 of 6   
date (3)    
function (2)    
archive file (1)    
archiving data (1)    
backup (1)    
convert (1)    
data (1)    
data mining (1)    
daylight (1)    
dba (1)    
miscellaneous (1)    
restore (1)    
savings (1)    
script (1)    
series (1)    
stairway series (1)    
t-sql (1)