Erlang Central

Difference between revisions of "Converting DMYHMS to Seconds"

From ErlangCentral Wiki

 
Line 27: Line 27:
  
  
[[Category:CookBook]]
+
[[Category:CookBook]][[Category:DateTimeRecipes]]

Revision as of 00:09, 4 September 2006

Problem

You want to convert a date, a time, or both with distinct values for day, month, year, etc. to seconds.

Solution

First, it is important to note that time (in Erlang) is always an integer based on a platform-specific starting date, an Epoch, (with a platform-specific minimum and maximum value). Keeping that into consideration, and using various Erlang built-in functions, we can get the number of seconds of a given date, and time. For instance, to get the seconds corresponding to the date, and time: "Wed Apr 21 13:01:01-0500 2004" you could simply:

1> LocalDateTime={{2004,04,21},{13,01,01}}.
{{2004,4,21},{13,1,1}}
2> calendar:datetime_to_gregorian_seconds(LocalDateTime).
63249771661

All of Erlangs date functions are in compliance with the Gregorian calendar, with its Epoch at year 0. So, the seconds value may differ from what we would expect from most UNIX languages (which would record their Epoch as January 1, 1970). So these languages would report a value of 1082570461, rather than 63249771661.

To prove this, let's get the gregorian seconds for 12:00:00 AM on January 1, 1970:

3> UnixEpoch={{1970,1,1},{0,0,0}}.
{{1970,1,1},{0,0,1}}
4> calendar:datetime_to_gregorian_seconds(UnixEpoch).
62167219200
5> 63249771661 - 62167219200.
1082552461