Home
TeamSite
DST patches were made, still showing old rules
System
OD 6.1.1 / Win 2003 / SQL Server
I've patched OD and Windows with the appropriate patches and I've tried deploying a timestamp to SQL Server as the following: 2007-03-28 12:00:00 EDT -- by 2007 rules, that day will be in DST, but when I run a select query on that column, SQL Server reports it as 11:00.
Am I missing something?
Dave
Find more posts tagged with
Comments
Migrateduser
Update:
I ran the following query and was happy to get the expected result...
SELECT dateadd(SECOND, 30, '2007-03-11 01:59:50.000')
Result: 3/11/2007 3:00:20 AM
But then, why the discrepancy with Datadeploy?