Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Time Zone Expression help. Expand / Collapse
Author
Message
Posted Monday, August 25, 2014 2:49 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 11:20 AM
Points: 243, Visits: 992

Here is my source data as an example

Date
2/1/2014 05:28:13 AM
2/1/2014 05:31:21 AM
2/1/2014 05:54:16 AM
2/1/2014 10:20:50 AM
2/1/2014 11:50:15 AM
2/1/2014 12:01:29 PM

This is in PST, I want to change in EST. I am using SSIS, any help would be great appreciate.
Post #1607253
Posted Monday, August 25, 2014 2:54 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:19 AM
Points: 321, Visits: 681
declare @d datetime = '2/1/2014 05:28:13 AM'
select dateadd(HOUR,-3,@d)

Post #1607256
Posted Monday, August 25, 2014 3:23 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 11:20 AM
Points: 243, Visits: 992
Thank You, So Much!
Post #1607265
Posted Monday, August 25, 2014 3:29 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 11:20 AM
Points: 243, Visits: 992
qq it should be +3 not -3, am i right?


declare @d datetime = '2/1/2014 05:28:13 AM'
select dateadd(HOUR,+3,@d)

The time I am receiving is PST and want to convert in EST. am i right?
Post #1607266
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse