Unix Date format to Normal date format

[ykoppisetty]

Please help me to convert this below UNIX date format to regular date format,

1445910469510

[j_angelevski]

Hi @ykoppisetty

You can use the Date.parse() function.
You need to pass the unix timestamp as a parameter.

Input

Date.parse(1445910469510)

Output

2015-10-27T01:47:49.510 Etc/UTC

[ykoppisetty]

Hi @j.angelevski can you tell how to get dynamically?

For example, the below field contain all the UNIX date formats so how to get normal date formats dynamically?

Modified_Date
1445910469510
1443298668240
1428458098640

[shashish_jha]

Date.parse($your_input_date).toLocaleDateTimeString({“format”:“yyyy-MM-dd HH:mm:ss”})
You can change your desired formatting in this section : “format”:“yyyy-MM-dd HH:mm:ss”
Place this expression into mapper snap and dynamically your_input_date will be picked up and formatted accordingly.

[ykoppisetty]

Hi @j.angelevski @shashish.jha
When I am trying through dynamically I am getting the below error.

Can you please resolve this error. I have also tried the @shashish.jha formula. But that’s also getting error. Please help me on this.

Thank you.