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 ,

 

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.

 

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