Trouble with Python String to Datetime

Question

I have the following string in Python - 'Oct 01 2013 07 30 PM EST'. I'm trying to convert to a datetime object but am getting the following error:

ValueError: time data 'Oct 01 2013 07 30 PM EST' does not match format
'%b %d %Y %I %M %p %Z'

Not sure where I am going wrong! Please help. My code is below:

from datetime import datetime
date_object = datetime.strptime(str(date), '%b %d %Y %I %M %p %Z')

the reason is timezone. please check this question stackoverflow.com/questions/1703546/… — oleg
– oleg, Commented Sep 22, 2013 at 19:50
Ah, thank you! I just removed the timezone and it works now. — sewardth
– sewardth, Commented Sep 22, 2013 at 23:56

SheetJS · Accepted Answer · 2013-09-22 19:51:43Z

3

Python strptime is platform-dependent:

http://docs.python.org/2/library/time.html#time.strptime

Support for the %Z directive is based on the values contained in tzname and whether daylight is true. Because of this, it is platform-specific except for recognizing UTC and GMT which are always known (and are considered to be non-daylight savings timezones).

On my kit (OSX 10.8.5, python 2.7.2), for example, datetime.now().strftime("%Z") is an empty string.

There are external libraries like http://pytz.sourceforge.net/ to help with timezones

answered Sep 22, 2013 at 19:51

SheetJS

23k12 gold badges68 silver badges76 bronze badges

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

Comments

Mingyu · Accepted Answer · 2013-09-22 20:02:51Z

1

There are two EST, which cause the confusion: http://en.wikipedia.org/wiki/List_of_time_zone_abbreviations

Eastern Standard Time (North America)   UTC-05
Eastern Standard Time (Australia)       UTC+10

edited Sep 22, 2013 at 20:02

answered Sep 22, 2013 at 19:54

Mingyu

33.8k14 gold badges58 silver badges63 bronze badges

1 Comment

SheetJS Over a year ago

While technically true, that is not the origin of the issue at hand. Try a 3-letter code that is unique (like EDT, eastern daylight time)

Collectives™ on Stack Overflow

Trouble with Python String to Datetime

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related