Akhilesh Jaiswal
Akhilesh Jaiswal

Reputation: 237

Azure Data Factory: How to convert UTC datetime to unix Timestamp

How to convert UTC datetime to unix Timestamp? example: 2021-11-08T07:25:00Z to 1636385119

Upvotes: 1

Views: 3424

Answers (1)

KarthikBhyresh-MT
KarthikBhyresh-MT

Reputation: 5044

In ADF Pipeline:

@{div(sub(ticks(utcNow()), ticks('1970-01-01')),10000000)}

enter image description here

enter image description here

In Data flow:

As explained here in doc: Convert to dates or timestamps

toLong( currentUTC() - toTimestamp('1970-01-01 00:00:00.000', 'yyyy-MM-dd HH:mm:ss.SSS') ) * 1000l

Upvotes: 3

Related Questions