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

Articles with tag Datetime Manipulation Rss

Search for any content tagged datetime manipulation

   Items 1 to 9 of 9   
 

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,935 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,935 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 | 851 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,247 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,952 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,082 reads

New datetime datatypes in SQL Server 2008

Older versions of SQL Server had only one datatype to store both the date and time values. In SQL Server 2008, Microsoft introduces a set of new datatypes that store date and time individually, and both date and time together.  Read more...
By Additional Articles 2008/01/21 | Source: Database Journal | Category: sql server 2008
Rating:  Rate this |   Briefcase | 2,650 reads

Using the DATE data type in SQL Server 2008

In SQL Server 2008 we get a new DATE date type that allows you to store a date without a time.  Read more...
By Additional Articles 2007/12/18 | Source: SQLTeam.com | Category: datetime manipulation
Rating:  Rate this |   Briefcase | 3,424 reads

Working with Time Spans and Durations in SQL Server

What is the best way to return the "duration" of an event in SQL, given the start and end datetime values? How can we add up these durations to return grand totals? What data types should be used to return this data to our clients? How do we handle overflows, such as when hours go over 23 or minutes total up to over 59? Are there any T-SQL functions or other techniques that are useful in these scenarios?   Read more...
By Additional Articles 2007/10/24 | Source: SQLTeam.com | Category: t-sql
Rating:  Rate this |   Briefcase | 3,771 reads
   Items 1 to 9 of 9