Share via

Time Zone Addition to the UTC Time In Azure Data Factory ETL

Abhilash Reddy Yerasi 6 Reputation points
2020-07-28T05:20:20.4+00:00

Hi MS Community

Looking for help in order to add certain duration to the time stamps variable. Which i specific to the various time zones.

Looked for the functions such as addHours, addMinutes an converToTimeZone.

Can any one help in how to tackle this.

Note using Mapping Data Flow.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,639 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. DanielP-MSFT 171 Reputation points
    2020-07-28T07:00:12.63+00:00

    You can use the add() function and the '+' operator to add timestamps together.

    For example:

    toTimestamp('2019-02-03 05:19:28.871', 'yyyy-MM-dd HH:mm:ss.SSS') + (days(1) + hours(2) - seconds(10)) -> toTimestamp('2019-02-04 07:19:18.871', 'yyyy-MM-dd HH:mm:ss.SSS')

    The toTimestamp() function takes in time zone as a parameter as well if you are not working with UTC times. More info can be found here

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.