Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Expression language - Convert ISO 8601 to unixtimestamp

Expression language - Convert ISO 8601 to unixtimestamp

New Contributor

Hi Guys,

I am having trouble converting the ISO 8601 to a unixtimestamp .

Here is what i have tried current_ts: 2018-11-11T00:17:27.937000 Using updateAttribute, I have configured the below property

${current_ts:toDate("yyyy-MM-dd'T'HH:mm:ss.SSSSSS"):toNumber()}

This gives the Output value : 1541863984000

if converted back from epochcoverter, its giving

Assuming that this timestamp is in milliseconds: GMT: Saturday, 10 November 2018 15:33:04

Your time zone: Sunday, 11 November 2018 00:33:04 GMT+09:00

Relative: 22 days ago

I have also tried using ${current_ts:toDate("yyyy-MM-dd'T'HH:mm:ss.SSSSSS", "UTC"):toNumber()} but the result is the same. Kindly help finding out correct expression.

Regards,

Faisal

Don't have an account?
Coming from Hortonworks? Activate your account here