Using SqlServer 2008 and TSQL Subtract 1 Hour From All Values In a DateTime Column

Posted on Dot net Slackers See other posts from Dot net Slackers
Published on Wed, 28 Apr 2010 00:00:00 GMT Indexed on 2010/04/29 2:57 UTC
Read the original article Hit count: 548

Filed under:
In this post, well go briefly the process of how you would update all rows in a SQL Server 2008 table such that a particular date column will be moved back 1 hour in time.  This is actually... This site is a resource for asp.net web programming. It has examples by Peter Kellner of techniques for high performance programming...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.



Email this Article

© Dot net Slackers or respective owner

Using SqlServer 2008 and TSQL Subtract 1 Hour From All Values In a DateTime Column

Posted on Dot net Slackers See other posts from Dot net Slackers
Published on Wed, 28 Apr 2010 00:00:00 GMT Indexed on 2010/04/29 0:48 UTC
Read the original article Hit count: 548

Filed under:
In this post, well go briefly the process of how you would update all rows in a SQL Server 2008 table such that a particular date column will be moved back 1 hour in time.  This is actually pretty simple, but being that I typically do my work in the ORM layer (that is LINQ2SQL [...]...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.



Email this Article

© Dot net Slackers or respective owner