Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (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?