Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Add UTC offset to client time

Hi, i have some problems with UTC time.   Data in my reports is 2 hours less than real.   I tryed to convert hour to my timezone and it works but by this way i have hour +offest.   Example: 2...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    Enter into Query Editor, Transform -> Date/Time/TimeZone. For example like picture below:

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

Yes, we have successfully added the time Zone information into the time. Then you can select NewTime column, navigate to Transform tab, choose data type and select Date/Time/TimeZone. For example like picture below:

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Doesn't work

 

It doesn't add offset to hour.

 

I choose "Date/Hour"

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi Anonymous ,

     

    Don't forget to click "Close &Apply".

     

    Best Regards,

    Amy

     

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi Anonymous ,

     

    Enter into Query Editor, Transform -> Date/Time/TimeZone. For example like picture below:

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Yes but this only format column.

     

    I dont want hour +offset. i only want hour.

     

    Not 06/10/2019 11.20.00 +2.00 but i want 06/10/2019 13.20.00 .

     

     

    Do you understand?