Showing results for 
Search instead for 
Did you mean: 

Date Epoch Example

Former Employee

An epoch date is either the number of seconds or milliseconds since 1 January 1970 00:00:00 UTC. UNIX and other applications use seconds, while JavaScript uses milliseconds. SnapLogic uses JavaScript as its scripting language, so the epoch date is internally stored as milliseconds since epoch.

In the example below, we are passing in the date in seconds since epoch.

1 - Set a project parameter. In my example, I have “dateEpoch” set to 1472799302.
2 - Use the following formula in a mapper snap:
Date.parse(Date.parse(1000*_dateEpoch).toString()).toLocaleDateTimeString(‘{“timeZone”:“America/Chicago”, “format”:“MM-dd-yyyy HH:mm:ss”}’)

This returns a value of: 09-02-2016 01:55:02

Further examples:

Date.parse(1000*_dateEpoch) = “2016-09-02T06:55:02.000 Etc/UTC”

Date.parse(1000*_dateEpoch).toString() = “2016-09-02T06:55:02.000Z”

date test epoch_2017_02_28.slp (4.6 KB)


New Contributor III

Thanks for providing this example to convert epoch to date.

Do you have an example to convert date to epoch ?