For Chargebee data, dates and times come in as unix epoch dates and times. Unix epoch time is a system for describing instants in time. It is shown in the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC), Thursday, 1 January 1970. If a metric returns points in time in unix time, it will likely show up in milliseconds. You can use SQLite to change it into a readable date and time.

Grow helps you transform these dates and times using SQLite. To do that, read our help article here.

Questions? Chat in on the site and we'll be happy to help.

Did this answer your question?