http://www.sqlservercentral.com/Content tagged Datetime Manipulation posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Calculates a past or future date based upon supplied parameters. Returns a datetimehttp://www.sqlservercentral.com/scripts/Datetime+Manipulation/62123/2008/03/24http://www.sqlservercentral.com/scripts/Datetime+Manipulation/62123/This article is going to cover the newly introduced data types in SQL Server 2008 July CTP, and will specifically discuss the DATETIME functions.http://www.sqlservercentral.com/redirect/articles/62144/2008/02/18http://www.sqlservercentral.com/redirect/articles/62144/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.http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/2008/02/06http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/You Can Find Some Date Functions and extracting the different Date Formats using the Convert and Casthttp://www.sqlservercentral.com/scripts/Datetime+Manipulation/61393/2008/02/01http://www.sqlservercentral.com/scripts/Datetime+Manipulation/61393/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.http://www.sqlservercentral.com/scripts/Scalar-valued+Functions/61567/2008/01/22http://www.sqlservercentral.com/scripts/Scalar-valued+Functions/61567/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.http://www.sqlservercentral.com/redirect/articles/61922/2008/01/21http://www.sqlservercentral.com/redirect/articles/61922/In SQL Server 2008 we get a new DATE date type that allows you to store a date without a time.http://www.sqlservercentral.com/redirect/articles/61700/2007/12/18http://www.sqlservercentral.com/redirect/articles/61700/Calculates the nth due date for any given date, while accounting for weekends.http://www.sqlservercentral.com/scripts/User-defined+function/61300/2007/12/03http://www.sqlservercentral.com/scripts/User-defined+function/61300/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? http://www.sqlservercentral.com/redirect/articles/61336/2007/10/24http://www.sqlservercentral.com/redirect/articles/61336/