CODEWITHSUNDEEP
pentahokettlepentaho-data-integration
M.E.
M.E.

Reputation: 5496

Convert timestamp to epoch Pentaho PDI 8 CE

I want to convert a timestamp 2019/02/12 00:00:00.000 into Epoch time 1549486845.

I see many posts about doing the opposite conversion, but how can you convert it from timestamp to epoch?

Pentaho PDI 8 CE

Upvotes: 1

Views: 1573

Answers (1)

M.E.
M.E.

Reputation: 5496

I just used a Select Values step which convert the timestamp field to integer and then it is divided by 1000 in an User defined Java Expression.

Upvotes: 2

Related Questions