Python: UTC timestamp from pytz localized timestamp

Question

I am trying to convert timestamp strings to the equivalent seconds from the unix epoch using pytz. I'm puzzled by the output of the below code.

import datetime
import pytz

exif = '2008:05:03 16:23:16'
dtexif = datetime.datetime.strptime(exif, '%Y:%m:%d %H:%M:%S')
print dtexif

zrh = pytz.timezone('Europe/Zurich')
tztime = zrh.localize(dtexif)
print tztime

tzfloat = float(tztime.astimezone(pytz.utc).strftime('%s'))
utctime = pytz.utc.localize(datetime.datetime.fromtimestamp(tzfloat))
print utctime

print 'seconds since epoch: %.1f' % tzfloat

With pytz-2016.10, it prints:

2008-05-03 16:23:16
2008-05-03 16:23:16+02:00
2008-05-03 15:23:16+00:00
seconds since epoch: 1209849796.0

I would expect the second last line to be:

2008-05-03 14:23:16+00:00

And I'm baffled by the last line, which represents 2008-05-03T21:23:16+00:00 according to http://www.unixtimestamp.com/

Where am I going wrong?

It looks like pytz already took care of that via localize(). The right offset (+2:00) for daylight savings is applied. — mrtasktat
– mrtasktat, Commented Jan 30, 2017 at 6:05

Community · Accepted Answer · 2017-05-23 10:29:30Z

3

Looks like I didn't search hard enough, this was addressed here: python - datetime with timezone to epoch

The line to calculate tzfloat should be:

tzfloat = (tztime - datetime.datetime(1970, 1, 1, tzinfo=pytz.utc)).total_seconds()

I had wrongly assumed the timestamp would already be relative to the epoch.

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Jan 30, 2017 at 6:30

mrtasktat

3451 gold badge5 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Python: UTC timestamp from pytz localized timestamp

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related