http://www.sqlservercentral.com/Content tagged T-SQL, Datetime Manipulation posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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/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/