python converting any datetime string to UTC

Question

I have a tedious function that does something like this:

...
if ('PDT' in stringVal) or ('PST' in stringVal):
    utcdateTime = convert(stringVal)+(hardcode the offset)
elif('EDT' in stringVal)...
...

I looked at several posts including this but couldn't find anything that fits my purpose. I also looked at datetime.datetime and the whole datetime module in general but it has things like .now(); .utcnow(); datetime.now(tz.pytz.utc) etc etc. Basically if I have something like:

2014-05-01 01:02:03 PDT
2014-05-01 01:02:03 PST
2014-05-01 01:02:03 EDT
2014-05-01 01:02:03 EST
2014-05-01 01:02:03 MDT
2014-05-01 01:02:03 MST

Is there a python module that has some method I can use to convert those above datetime strings to UTC? If there is none, I will just stick with the hard-coded way I have.

Not exactly a duplicate, but a similar / inverse problem. You should find how to parse timezones and convert from local to utc in the answers. — viraptor, Apr 13 '16 at 00:38
Neither of those seem to be duplicates, one doesn't deal with timezones, and the other is doing the reverse, converting from UTC — Brendan Abel, Apr 13 '16 at 00:38
@BrendanAbel The reverse is not really the reverse. You're using `.astimezone(...)` with timezone as a parameter. Surely if you can write any Python at all, you can generalise that answer. — viraptor, Apr 13 '16 at 03:10
@viraptor I am going to try the solution in that post. Not a duplicate but something similar. I will try their way — Nikhil Gupta, Apr 13 '16 at 14:57

Brendan Abel · Answer 1 · 2016-04-13T03:21:29.433

2

You'll need to translate the timezone strings, but otherwise you can use the datetime and pytz libraries.

import datetime
import pytz

s = '2014-05-01 01:02:03 PST'
ds, tzs = s.rsplit(' ', 1)

tz_map = {
    'PST': 'US/Pacific', 
    'EST': 'US/Eastern'
}
tz = pytz.timezone(tz_map[tzs])

dt = datetime.datetime.strptime(ds, '%Y-%m-%d %H:%M:%S').replace(tzinfo=tz)
dt_utc = dt.astimezone(pytz.utc)

edited Apr 13 '16 at 03:21

answered Apr 13 '16 at 00:42

Brendan Abel

35,343
14
88
118

On line 5 there is an error: splitting by `' '` will result in three values being returned, not two. – Cyb3rFly3r Apr 13 '16 at 03:21
Thanks, there was supposed to be a 1 as the second arg. – Brendan Abel Apr 13 '16 at 03:21
@BrendanAbel how would this handle "PDT" and "EDT" etc? – Nikhil Gupta Apr 13 '16 at 15:23
They use the same timezone as PST, EST. Pytz will use the correct one based on the date. If you actually want to force PDT during a PST date, you can use `timezone.localize` with a PDT date to get a static PDT timezone. – Brendan Abel Apr 13 '16 at 15:27
@BrendanAbel I tried using your code which works great but when I used "PDT" in the string, the UTC time was off by an hour. – Nikhil Gupta Apr 13 '16 at 19:44

python converting any datetime string to UTC

1 Answers1