Add times in ADF Data flow

Vivek Komarla Bhaskar 911 Reputation points
2022-09-29T12:58:45.833+00:00

How to add times in data flow expression builder HH:mm:ss.fff? As per the screenshot below I want to perform below -

TX Time + TX Duration -> To get TXEndTime
Planned Time + Planned Duration -> To get PlannedEndTime

There is no time datatype which I can use, I can only see date and timestamp. Also there are no functions like DATEADD / DATEDIFF to add times, Please advise how can this be achieved?

246064-screenshot-2022-09-29-at-135630.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,599 questions
Accepted answer
  1. MarkKromer-MSFT 5,186 Reputation points Microsoft Employee
    2022-09-29T21:11:31.9+00:00

    https://learn.microsoft.com/en-us/azure/data-factory/data-flow-date-time-functions

    add Adds a pair of strings or numbers. Adds a date to a number of days. Adds a duration to a timestamp. Appends one array of similar type to another. Same as the + operator.
    addDays Add days to a date or timestamp. Same as the + operator for date.
    addMonths Add months to a date or timestamp. You can optionally pass a timezone.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest