Trying to convert to datetime

Question

I am using datetime to convert a time string. I used the reference for the specifying the format. How should I have coded the format?

In [19]:import datetime In [20]: d Out[20]: 'Oct. 30, 2014, 6:17 a.m.' In [21]: format Out[21]: '%b. %d, %Y, %I:%M%p.' In [22]: date_object = datetime.datetime.strptime(d, format) --------------------------------------------------------------------------- ValueError Traceback (most recent call last) <ipython-input-22-78ccb659d6ac> in <module>() ----> 1 date_object = datetime.datetime.strptime(d, format) /usr/lib/python2.7/_strptime.pyc in _strptime(data_string, format) 323 if not found: 324 raise ValueError("time data %r does not match format %r" % --> 325 (data_string, format)) 326 if len(data_string) != found.end(): 327 raise ValueError("unconverted data remains: %s" % ValueError: time data 'Oct. 30, 2014, 6:17 a.m.' does not match format '%b. %d, %Y, %I:%M%p.'

I came across this tool, "dateutil" and

In [20]: d Out[20]: 'Oct. 30, 2014, 6:17 a.m.' In [34]: from dateutil import parser In [35]: date_obj = parser.parse(d) In [36]: date_obj Out[36]: datetime.datetime(2014, 10, 30, 6, 17)

I get this

/home/tilaprimera/.virtualenvs/picovico/lib/python2.7/site-packages/django/db/models/fields/__init__.py:1278: RuntimeWarning: DateTimeField GCMDevice.created_at received a naive datetime (2014-10-30 06:17:00) while time zone support is active. RuntimeWarning)

The thing is, I am trying to query the database with this time but unfortunately, with some information lost, I do not get a match on the time.

I guess the problem is what it says your string "does not match format" your provided. Please double check it. — Marcin
– Marcin, Commented Jan 15, 2015 at 6:36

Community · Accepted Answer · 2017-05-23 12:06:26Z

Close, but no cigar. I figured it out by doing datetime.datetime.now().strftime() with your format string and playing around a bit. You need two changes:

d = 'Oct. 30, 2014, 6:17 AM' format = '%b. %d, %Y, %I:%M %p'

There is unfortunately no format specifier that accepts a.m. (at least not in the English locale I tried). For more on this, see here: https://stackoverflow.com/a/2925280/4323

tharen · Accepted Answer · 2015-01-15 06:58:11Z

Since 'a.m.' is non standard you could substitute it using the re module. Also, you do not have a space in your format string after the minute position.

import datetime import re d='Oct. 30, 2014, 6:17 a.m.' format='%b. %d, %Y, %I:%M %p' d = re.sub('([pa])\.m\.',r'\1m',d) date_object = datetime.datetime.strptime(re.sub('([pa])\.m\.',r'\1m',d),format)

Collectives™ on Stack Overflow

Trying to convert to datetime

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related