Azure Data Factory convert EnqueuedTimeUtc to Unix timestamp-CodePudding

I have a Data Flow that gets data from an EventHub.

The events have a system property called EnqueuedTimeUtc:

I want to convert the value of EnqueuedTimeUtc to Unix timestamp or at least to DateTime in Data Factory.

There's aso a property called SystemProperties. It has a property called x-opt-enqueued-time. I want to get the value of x-opt-enqueued-time as a column.

But if I try to Parse the SystemProperties column I got the following error:

Is there a way of doing this?

Thanks!

CodePudding user response：

toTimestamp('04/12/2022 08:40:39 PM','MM/dd/yyyy HH:mm:ss') - toTimestamp('1970-01-01 00:00:00.000', 'yyyy-MM-dd HH:mm:ss.SSS')