user290043
user290043

Reputation:

How to convert a Date string to a DateTime object?

I have following date:

2005-08-11T16:34:33Z

I need to know if this is date is before or after datetime(2009,04,01) and I can't seem to find a method that will convert that string to something that lets me compare it to datetime(2009,04,01) in a meaningful way.

Upvotes: 20

Views: 36639

Answers (3)

Lukas N.P. Egger
Lukas N.P. Egger

Reputation: 963

I'd recommend taking a look at: http://dateutil.readthedocs.io/en/stable/parser.html

from dateutil.parser import parse datetime = parse("Sat Oct 11 17:13:46 UTC 2003")

Upvotes: 1

The Jug
The Jug

Reputation: 1165

If you know the string just use the datetime.datetime(year, month, day, hour, minute, second) function. Split your string to get the appropriate variables and put it in to make it a datetime type. Then just compare it against whatever you need.

Or you can use the iso format as people have suggested also.

Upvotes: 0

Alex Martelli
Alex Martelli

Reputation: 881635

Since the string is in ISO format, it can be meaningfully compared directly with the ISO format version of the datetime you mention:

>>> s='2005-08-11T16:34:33Z'
>>> t=datetime.datetime(2009,04,01)
>>> t.isoformat()
'2009-04-01T00:00:00'
>>> s < t
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
TypeError: can't compare datetime.datetime to str
>>> s < t.isoformat()
True
>>> z='2009-10-01T18:20:12'
>>> z < t.isoformat()
False

as you see, while you can't compare string with datetime objects, as long as the strings are in ISO format it's fine to compare them with the .isoformat() of the datetime objects. That's the beauty of the ISO format string representation of dates and times: it's correctly comparable and sorts correctly as strings, without necessarily requiring conversion into other types.

If you're keen to convert, of course, you can:

>>> datetime.datetime.strptime(s, '%Y-%m-%dT%H:%M:%SZ')
datetime.datetime(2005, 8, 11, 16, 34, 33)

Upvotes: 36

Related Questions