ADF: Time format (AM/PM) to utc

Question

I have a column where timestamp is '5/23/2022 8:45:34 PM'. I want to create a new column with same data but in UTC format 'yyyy-MM-dd HH:mm:ss' and this new datetime format is 7 hours behind UTC (UTC-7)

I tried doing in azure data factory derived column using toTimestamp before it converts to UTC but it always fail.

toTimestamp('11/04/2020 6:17:40 PM', 'dd-MM-yyyy HH:mm:ss')

but it always return NULL.

Expecting output format: 'dd-MM-yyyy HH:MM:ss'
Can anyone help this data conversion to UTC ?

Answer 1

Hey
You can use derived column in dataflow with the below expression :

toTimestamp(date, 'MM/dd/yyyy hh:mm:ss a', 'UTC')