Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Datetime Manipulation Rss

Search for any content tagged datetime manipulation

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 6 of 6   
 

Financial Month

This Script will return the respective financial month(Starts from April to March) for a calander month Input(Starts from January to April), May use for many Consolidated Financial Reports.  Read more...
By Kartik M Kumar 2011/02/16 | Source: SQLServerCentral.com | Category: datetime manipulation
Rating: |  Discuss |   Briefcase | 1,452 reads

Nth occurrence of a weekday in a month and year

To find date at nth occurrence of a weekday in a month and year  Read more...
Rating: |  Discuss |   Briefcase | 718 reads

fn_getDateAway - Calculates a date based upon arguments specified

Calculates a past or future date based upon supplied parameters. Returns a datetime  Read more...
By Jeff Luckett 2008/03/24 | Source: SQLServerCentral.com | Category: datetime manipulation
Rating: |  Discuss |   Briefcase | 968 reads

Calculating the Number of Business Hours Passed Since a Point of Time

A set of user defined functions used to calculate the number of business or working hours (excluding the non working hours) that have passed since a certain point of time.  Read more...
Rating: |  Discuss |   Briefcase | 2,723 reads

Different Date Formats

You Can Find Some Date Functions and extracting the different Date Formats using the Convert and Cast  Read more...
By Vinuraj R 2012/03/23 | Source: SQLServerCentral.com | Category: datetime manipulation
Rating: |  Discuss |   Briefcase | 3,528 reads

Payment due date function

Calculates the nth due date for any given date, while accounting for weekends.  Read more...
Rating: |  Discuss |   Briefcase | 2,554 reads
   Items 1 to 6 of 6