Post reply

Time Zone Expression help.

  • August 25, 2014 at 2:49 pm

    #298711

    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.

  • August 25, 2014 at 2:54 pm

    #1740870

    declare @d datetime = '2/1/2014 05:28:13 AM'

    select dateadd(HOUR,-3,@d)

  • August 25, 2014 at 3:23 pm

    #1740875

    Thank You, So Much!

  • August 25, 2014 at 3:29 pm

    #1740876

    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?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply