When I transform the created_timestamp to Datetime field, it returns a date that does not exist. I think this data is badly formed in the api. It’s possible?
Hi @MarcosRedondo - There are various ways of converting a timestamp to a date - for example, you can use this tool.
So, in your case, the timestamp converts to 2018-10-23-15-24-57 (YYYY-MM-DD-HH-MM-SS)
mmm it’s weird because if I use the tool it returns the correct result but my php function returns an incorrect result:
I will continue looking for the reason!!
PHP timestamps are in seconds, whereas that tool when it sees the big number says: Assuming that this timestamp is in milliseconds
if we try
echo date('Y-m-d H:i:s', 1540193140046/1000);
and we get the result that we expect:
2018-10-22 09:25:40
Thanks for sharing your solution! That will be really helpful for others
