Getting timestamp from unix second
![farhanromli](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar2.png)
farhanromli
Registered Posts: 25 ✭✭✭✭
Is it possible to get timestamp from unix epoch seconds using Prepare Recipe?
For example given the epoch second = 1459149667, then the unix timestamp is 2016-03-28 07:21:07 (date format does not matter as long it is in UTC)
Operating system used: Windows 10
Best Answer
-
Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 Dataiker
Hi,
You can use the 'Convert UNIX timestamp to a date' processor for that operation.
Answers
-
I have tried below but did not work. Or did I make a mistake?
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
try unchecking the treat input as millisecond option. That should work better.
-
Yes, I just realised that and was about to update but thanks!