Timezone related question

Vivek Komarla Bhaskar 911 Reputation points
2023-03-07T12:33:49.95+00:00

Hi,

An API I am using fetches viewer usage data related to a website, and it has a datetime column set in UTC time. The question I have is if I'm reading this from Europe/London timezone, and during daylight saving Europe/London time is +1hr over UTC, in this case, if I have the data as below coming from API:

DataTime Viewer

2023-03-27 07:00:00 400

2023-03-27 08:00:00 400

2023-03-27 08:59:00 400

2023-03-27 09:01:00 400

Should I read/understand/interpret this information this way?

DataTime Viewer

2023-03-27 08:00:00 400

2023-03-27 09:00:00 400

2023-03-27 09:59:00 400

2023-03-27 10:01:00 400

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,991 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MayankBargali-MSFT 70,006 Reputation points
    2023-03-10T05:12:38.81+00:00

    @Vivek Komarla Bhaskar Thanks for reaching out. Please correct if my understanding is right. You are making the HTTP request on your API from logic app and want to understand how you should treat the data in the logicapp.

    If your data is in the any of the format then you can use the convertTimeZone function to convert the source time to the destination time and it should automatically take care for the daylight saving depending on the source and destination time zone.

    0 comments No comments