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

Content with tag Datetime Manipulation Rss

   Items 1 to 20 of 24    Older >>
 

DateTime data types

By Sasidhar Pulivarthi 2013/04/11 | Category: datetime manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,795 reads

Deterministic

By Joe Barth 2013/03/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,038 reads

New Year's Math

By Steve Knox 2013/01/03 | Category: datetime functions
Rating: (not yet rated) |  Discuss |   Briefcase | 2,253 reads

Payment due date function

Calculates the nth due date for any given date, while accounting for weekends.  Read more...
Rating: |  Discuss |   Briefcase | 2,540 reads

DateTime Puzzle

By Sunil Chandurkar 2012/05/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,482 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,504 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,646 reads

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,443 reads

SQL Server 2008 T-SQL Enhancements Part - II

Continuing with his series on changes in SQL Server 2008, Arshad Ali takes a look at table enhancements and new data types.  Read more...
By Arshad Ali 2010/03/12 (first published: 2009/07/27) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 28,933 reads

Datetime precision

By Craig Outcalt 2009/11/30 | Category: datetime manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 3,360 reads

DateTime Trick

By Volkan Kuyucuoglu 2009/10/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,449 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 | 716 reads

SQL Server 2008 T-SQL Enhancements Part - II

Continuing with his series on changes in SQL Server 2008, Arshad Ali takes a look at table enhancements and new data types.  Read more...
By Arshad Ali 2010/03/12 (first published: 2009/07/27) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 28,933 reads

Temporal Datatypes in SQL Server

In the first of a series of articles on the tricks of tackling temporal data in SQL, Joe Celko discusses SQL's temporal data types and agonizes over the fact that, although there are ANSI/ISO Standards for temporal operations in SQL, every vendor has something different.  Read more...
By Additional Articles 2008/12/31 | Source: SimpleTalk | Category: datetime manipulation
Rating: (not yet rated)  Rate this |   Briefcase | 849 reads

SQL Server Function to Determine a Leap Year

I need to write a function to determine if particular year is a leap year (i.e. February contains 29 days rather than 28 days). I know that there are various rules for calculating leap years. Is there an easy way to figure this out? Can you provide an example or two to validate various years?  Read more...
By Additional Articles 2008/07/14 | Source: MSSQLTips.com | Category: datetime manipulation
Rating:  Rate this |   Briefcase | 5,244 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 | 956 reads

SQL Server 2008 New DATETIME DataTypes

This article is going to cover the newly introduced data types in SQL Server 2008 July CTP, and will specifically discuss the DATETIME functions.  Read more...
Rating:  Rate this |   Briefcase | 3,950 reads

Generating Missing Dates and Numbers

Finding missing data in a sequence of numbers or dates is a common request of DBAs. Regular author Jacob Sebastian brings us a new article that shows just how you can do this.  Read more...
By Jacob Sebastian 2008/02/06 | Category: datetime manipulation
Rating: |  Discuss |   Briefcase | 8,080 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,504 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,646 reads
   Items 1 to 20 of 24    Older >>