Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Python dateutil.parser.parse parses month first, not day

I'm using dateutil.parser.parse to format a date from a string. But now it mixes up the month and the day.

I have a string that contains 05.01.2015. After

dateutil.parser.parse("05.01.2015")

it returns:

datetime.datetime(2015, 5, 1, 0, 0)

I hoped the it would return (2015, 1, 5, 0, 0)

How can I tell the code that the format is dd.mm.yyyy?

For the record, 25.01.2015 will be parsed as (2015, 1, 25, 0, 0), as expected.

like image 281
Timo002 Avatar asked Jan 06 '15 14:01

Timo002


2 Answers

Specify dayfirst=True:

>>> dateutil.parser.parse("05.01.2015", dayfirst=True)
datetime.datetime(2015, 1, 5, 0, 0)

This gives precedence to the DD-MM-YYYY format instead of MM-DD-YYYY in cases where the date format is ambiguous (e.g. when the day is 12 or lower). The function is documented here.

like image 131
Alex Riley Avatar answered Nov 17 '22 00:11

Alex Riley


You asked, 'How can I tell the code that the format is dd.mm.yyyy?'

Since you have already imported dateutil then most direct answer might be to specify the format of the date string but this is quite ugly code:

>>> dateutil.parser.datetime.datetime.strptime(date_string, '%d.%m.%Y')
datetime.datetime(2015, 1, 5, 0, 0)

We can see an obvious alternative embedded in the code. You could use that directly.

>>> from datetime import datetime
>>> datetime.strptime(date_string, '%d.%m.%Y')
datetime.datetime(2015, 1, 5, 0, 0)

There are also some newer alternative libraries that offer methods and properties aplenty.

Simplest to use in this case would be arrow:

>>> import arrow
>>> arrow.get(date_string, 'DD.MM.YYYY')
<Arrow [2015-01-05T00:00:00+00:00]>

Although I find the formatting for arrow easier to remember, pendulum uses Python's old formatting system which might save you having to learn arrow's.

>>> import pendulum
>>> pendulum.datetime.strptime(date_string, '%d.%m.%Y')
<Pendulum [2015-01-05T00:00:00+00:00]>
like image 5
Bill Bell Avatar answered Nov 17 '22 01:11

Bill Bell