Converting Unix Time Values

The Unix time is a system for representing a point in time. It is the number of seconds that have elapsed since January 1st, 1970 00:00:00 UTC (Unix epoch). For example, 2004-09-16T00:00:00Z is represented by the Unix time number 12677 × 24 x 60 x 60 = 1095292800, since it is 12677 days after the Unix epoch.

To convert UNIX time values, you can use the Date Parser Node with the xs format selected.

mceclip0.png

 

FAQ

What happens to 0 values?

  • Since 0 in the Unix time system represents January 1st, 1970 00:00:00 UTC, 0 values will be converted to January 1st, 1970 00:00:00 UTC. This does not include empty values.
Was this article helpful?
0 out of 0 found this helpful