Parsing datetime strings with microseconds in Python 2.5

Question

I have a text file with a lot of datetime strings in isoformat. The strings are similar to this:

'2009-02-10 16:06:52.598800'

These strings were generated using str(datetime_object). The problem is that, for some reason, str(datetime_object) generates a different format when the datetime object has microseconds set to zero and some strings look like this:

'2009-02-10 16:06:52'

How can I parse these strings and convert them into a datetime object?

It's very important to get all the data in the object, including microseconds.

NOTE: I have to use Python 2.5, the format directive %f for microseconds doesn't exist in 2.5.

Eli Bendersky · Accepted Answer · 2009-02-10 06:16:21Z

21

Alternatively:

from datetime import datetime

def str2datetime(s):
    parts = s.split('.')
    dt = datetime.strptime(parts[0], "%Y-%m-%d %H:%M:%S")
    return dt.replace(microsecond=int(parts[1]))

Using strptime itself to parse the date/time string (so no need to think up corner cases for a regex).

answered Feb 10, 2009 at 6:16

Eli Bendersky

276k92 gold badges372 silver badges427 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

denizb Over a year ago

Thanks for this answer! I'd suggest to change the last line to: return dt.replace(microsecond=int(1000 * float( '0.' + parts[1]))) this handles all cases correctly, like e.g. '2017-03-16 21:20:57.31' which should give 310us rather than 31us.

Soviut · Accepted Answer · 2009-02-10 06:23:30Z

11

Use the dateutil module. It supports a much wider range of date and time formats than the built in Python ones.

You'll need to easy_install dateutil for the following code to work:

from dateutil.parser import parser

p = parser()
datetime_with_microseconds = p.parse('2009-02-10 16:06:52.598800')
print datetime_with_microseconds.microsecond

results in:

answered Feb 10, 2009 at 6:23

Soviut

92.2k53 gold badges211 silver badges285 bronze badges

Comments

RSabet · Accepted Answer · 2009-02-10 06:18:02Z

5

Someone has already filed a bug with this issue: Issue 1982. Since you need this to work with python 2.5 you must parse the value manualy and then manipulate the datetime object.

edited Feb 10, 2009 at 6:18

answered Feb 10, 2009 at 6:07

RSabet

6,2003 gold badges29 silver badges26 bronze badges

Comments

David Z · Accepted Answer · 2009-02-10 06:14:45Z

2

It might not be the best solution, but you can use a regular expression:

m = re.match(r'(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})(?:\.(\d{6}))?', datestr)
dt = datetime.datetime(*[int(x) for x in m.groups() if x])

answered Feb 10, 2009 at 6:14

David Z

133k29 gold badges264 silver badges284 bronze badges

Collectives™ on Stack Overflow

Parsing datetime strings with microseconds in Python 2.5

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related