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 3 · Accepted Answer · answered Jul 18 '17 at 16:07

3

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

5,000
10
14

1

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

score 2 · Answer 2 · edited Dec 27 '22 at 23:28

2

Links below are outdated, currently for similar purpose one can use https://www.unixtimestamp.com/

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

edited Dec 27 '22 at 23:28

Tom Newton

93
1
8

answered Jul 18 '17 at 09:27

Greg Pagendam-Turner

973
2
13
20

2

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

score 2 · Answer 3 · edited Dec 27 '22 at 13:20

2

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 are working links to a few of such time converters:

https://timestamp.online

https://www.unixtimestamp.com

https://www.epochconverter.com

edited Dec 27 '22 at 13:20

RockPaperLz- Mask it or Casket

125
8

answered Jul 30 '19 at 14:13

Zonder

94
4

score 1 · Answer 4 · 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 5 · edited Dec 18 '21 at 14:21

1

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

3,037
6
27
40

answered Dec 17 '21 at 18:15

Alexandre Beck

11
1

score 1 · 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