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

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yes it works but it returns time +offset (01/05/2019 04.00.00 +2.00).

 

I don't want this. I want 01/05/2019 06.00.00 .

v-xicai wrote:

Hi Anonymous ,

 

Maybe you have missed the comma before "+2".

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

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

 

 

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 ,

       

      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?