What format are DMARC dates?

Question

I have a DMARC report that includes:

<date_range>
  <begin>1500249600</begin>
  <end>1500335999</end>
</date_range>

How do I convert the dates to something human?

score 1 · Answer 1 · answered Dec 03 '20 at 08:19

The date function in bash is quick and easy for casual conversion, such as when reading a DMARC report. On OSX:

$ date -jr 1606953599
Wed  2 Dec 2020 23:59:59 GMT

The -j flag prevents date from setting the date on your system. -r tells it there's a UNIX Time in seconds following, which is the DMARC report format for date_range fields.

score 1 · Answer 2 · answered Jul 18 '17 at 09:27

1

http://www.convert-unix-time.com/?t=1500249600 gives:

timestamp 1500249600 means:

In your local time zone: Monday 17th July 2017 10:00:00 AM UTC: Monday 17th July 2017 12:00:00 AM

http://www.convert-unix-time.com/?t=1500335999 gives: timestamp 1500335999 means:

In your local time zone: Tuesday 18th July 2017 09:59:59 AM UTC: Monday 17th July 2017 11:59:59 PM

answered Jul 18 '17 at 09:27

Greg Pagendam-Turner

873
2
12
19

1

These links are obsolete. See @Zonder's response which has working links. – MSC Oct 07 '21 at 21:59

score 1 · Accepted Answer · answered Jul 18 '17 at 16:07

1

There was a converter from DMARC, here it is https://dmarcian.com/dmarc-xml/

And AFAIR there's also converted dates. Correct me if I'm wrong.

answered Jul 18 '17 at 16:07

Strepsils

4,817
9
14

1

That's just what I need – Greg Pagendam-Turner Jul 18 '17 at 21:57

score 1 · Answer 4 · answered Jul 30 '19 at 14:13

I just got same question today and came to this post from Google search :)

However, it seems that site link, mentioned in previous answer, is no longer exist.

here is working links to few of such time converters:

http://timestamp.online

https://www.unixtimestamp.com

https://www.epochconverter.com

score 0 · Answer 5 · edited Dec 18 '21 at 14:21

0

Try on Linux command line:

date --date='@1500249600'
Sun 16 Jul 2017 05:00:00 PM PDT

edited Dec 18 '21 at 14:21

Paul

2,755
6
24
35

answered Dec 17 '21 at 18:15

Alexandre Beck

1

score 0 · Answer 6 · answered Sep 07 '22 at 23:01

If you are on a system with MySQL such as MacOS, etc, open up a CLI and type

mysql> select from_unixtime(1500249600);

You'll get: +---------------------------+ | from_unixtime(1661212800) | +---------------------------+ | 2022-08-22 17:00:00 | +---------------------------+ 1 row in set (0.02 sec)

score 0 · Answer 7 · answered Sep 07 '22 at 23:06

If you are on a system with MySQL such as MacOS, etc, open up a CLI and type

mysql> select from_unixtime(1500249600);

You'll get:

+---------------------------+
| from_unixtime(1500249600) |
+---------------------------+
| 2017-07-16 17:00:00       |
+---------------------------+
1 row in set (0.02 sec)

What format are DMARC dates?

7 Answers7