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

Content with tag Date Rss

   Items 1 to 16 of 16   
 

Calendar Table Function

This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently  Read more...
By Chris Kutsch 2016/01/25 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 3,825 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 2016/01/01 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 10,814 reads

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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,410 reads

Calendar Table Function

This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently  Read more...
By Chris Kutsch 2016/01/25 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 3,825 reads

In The Beginning

By Sean Pearce 2014/11/25 | Category: datetime
Rating: (not yet rated) |  Discuss |   Briefcase | 1,869 reads

Checking All Date Columns in a Table(s)

Find minimum and maximum values for all date columns in a table or range of tables, using a mask.  Read more...
By Larry Schmidt 2014/11/17 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 1,297 reads

PivotByDate clr stored procedure

This script pivots 1 to N numeric columns, grouping by 1 to N (N)(Var)char columns, pivoting by distinct date.  Read more...
By Louis Nardozi 2013/10/30 | Source: SQLServerCentral.com | Category: pivot
Rating: (not yet rated) |  Discuss |   Briefcase | 1,034 reads

Function to format a datetime variable by a mask

I have used the following function to convert dates according to desired textual formats that were not immediately available in the standard styles on offer.  Read more...
By Colin Frame 2013/10/18 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 1,621 reads

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,998 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,516 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,749 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,749 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,383 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 2016/01/01 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 10,814 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,133 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,407 reads
   Items 1 to 16 of 16   
 
Tags
calendar (3)    
datetime (3)    
function (3)    
time (3)    
date manipulation (2)    
formatting (2)    
holiday (2)    
t-sql (2)    
all columns (1)    
archive file (1)    
archiving data (1)    
calculate (1)    
complex (1)    
convert (1)    
date datatypes (1)    
dba (1)    
dimension (1)    
group (1)    
mask (1)    
miscellaneous (1)    
modulus (1)    
parameterization (1)    
pivot (1)    
populate (1)    
reference (1)    
smalldatetime (1)    
stairway series (1)