convert an epoch timestamp to datetime in azure data factory

Question

I'm working with data flow in azure data factory and i tried to convert an epoch formatted timestamp to date.

the value of the timestamp is '1574067907751' and i tried expressions : toDate(toTimestamp(1574067907751*1000l)) or toDate(toTimestamp(toInteger('1574067907751')*1000l,'yyyy-MM-dd HH:mm:ss'))

there is any other way to do that ?

user_7350788 · Answer

https://docs.microsoft.com/en-us/azure/data-factory/concepts-data-flow-expression-builder#convert-to-dates-or-timestamps

"To convert milliseconds from epoch to a date or timestamp, use toTimestamp(). If time is coming in seconds, multiply by 1,000.

toTimestamp(1574127407*1000l)

The trailing "l" at the end of the previous expression signifies conversion to a long type as inline syntax."

convert an epoch timestamp to datetime in azure data factory

1 Answers