Summary
The user is trying to convert Facebook marketing data date values from an ads_insights table to a timestamp. The date values are in the format of days appended to January 1, 1970, rather than following the Unix convention.
Question
Hey, I am exporting some facebook marketing data but the ads_insights tables have some very weird date values:
the int value for http://date_start.int|date_start.int_value is: 19504 how can i convert this to a timestamp; it doesn’t seem to be following the unix convention…
edit: figured this out, it’s just days appended to jan 1 1970
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.