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: 577
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.
© Dot net Slackers or respective owner
