Generally IoT dataset comes with epoch timestamp. Epoch timestamp is the number of seconds that has elapsed since January 1 1970 midnight (UTC). Epoch timestamp is also known in other names such as Unix Epoch, Unix timestamp, Epoch time, POSIX time etc.

Epoch is computer friendly format, but it is not user friendly. So in visualizations and graphical representations, we will have to use the standard datetime format. In this article, I will be explaining the tip to convert Epoch time to datetime.

The following expression solves the problem.

#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [EpochTime]/1000)

In the above expression, replace the EpochTime with the column name of the epoch timestamp in the dataset.

I hope this tip is helpful. Feel free to comment if you have any queries or feedback.

Advertisement