Forum Discussion

PeterGarant's avatar
PeterGarant
Helper I
9 years ago
Solved

Time Zones

Hi all   I have a problem with timezones. Our SQL server logs time in UTC, and our local machines are in UTC +1 (or +2 depending on DST).   So right now when I get data with time in it I know tha...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi PeterGarant,

     

    Based on my test, you can just use the formula below to add a custom column to get the expected Local time. :smileyhappy:

    = DateTimeZone.RemoveZone([CreatedUTC]) + #duration(0, DateTimeZone.ZoneHours([CreatedUTC]), 0, 0)

     

    Regards

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

You could split your UTC time field so that you get the offset and then create a column that adds or subtracts that time as appropriate.