Reputation: 237
How to convert UTC datetime to unix Timestamp? example: 2021-11-08T07:25:00Z to 1636385119
Upvotes: 1
Views: 3424
Reputation: 5044
@{div(sub(ticks(utcNow()), ticks('1970-01-01')),10000000)}
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