Forum Discussion

Keshavpooja's avatar
Keshavpooja
Frequent Visitor
4 years ago
Solved

Convert column from Datetimezone to Datetime - M Query

Hi Experts,   I am getting values from the source like '2021-02-10 20:48:24 +01:00' which has been assigned type 'DateTimeZone' in the Query Editor. I would like to store it as 'DateTime' format wi...
Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    Please try this expression.

     

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

     

     

    Pat

StefanoGrimaldi's avatar
StefanoGrimaldi
Icon for Resident Rockstar rankResident Rockstar
4 years ago

simple change the column to data/time/timezone first, them change it back to date/time or date/time using locale, so that should work and give you the date/time in the format you want 

  • Keshavpooja's avatar
    Keshavpooja
    Frequent Visitor
    4 years ago

    Hi,

    It does not work. Pls see the time closely. If i do like you said  i get only 20:48:24 but i would need 21:48:24

     

    Kesavan.