Erlang Central

# Converting DMYHMS to Seconds

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

## 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
```