How to convert hubspot timestamps to meaningful datetime?SOLVE
Jun 13, 2018 4:13 PM
We're importing the hubspot DB to our BigQuery.
On the hs.properties.hs_lifecyclestage_marketingqualifiedlead_date.value property I see strange value such as: 1525801948522, 1525774682022.
I could not figure out what timestamp they represent? (These are not Unix timestamps)
I want to convert them to a datetime which I could actually use SQL queries on.
Does anyone have an idea?
Solved! Go to Solution.