Apply timezone offset to datetime in Python

Question

For a given date string such as 2009-01-01T12:00:00+0100 I want the UTC datetime object.

from datetime import datetime 
datetime.strptime("2013-03-21T14:19:42+0100", "%Y-%m-%dT%H:%M:%S%z")

returns

datetime.datetime(2013, 3, 21, 14, 19, 42, tzinfo=datetime.timezone(datetime.timedelta(0, 3600)))

I cannot believe there is no method in datetime or pandas for applying the timezone-related offset to the datetime and returning plain UTC datetime.

How can I apply the tzinfo offset/delta, so that the resulting timezone is plain UTC (tzinfo=None)?

Landar · Accepted Answer · 2018-09-17 17:13:03Z

7

This feels a bit dirty but it does work

from datetime import datetime
orig_dt = datetime.strptime("2013-03-21T14:19:42+0100", "%Y-%m-%dT%H:%M:%S%z")  # datetime.datetime(2013, 3, 21, 14, 19, 42, tzinfo=datetime.timezone(datetime.timedelta(0, 3600)))
utc_time_value = orig_dt - orig_dt.utcoffset()
utc_dt = utc_time_value.replace(tzinfo=None)  # datetime.datetime(2013, 3, 21, 13, 19, 42)

answered Sep 17, 2018 at 17:13

Landar

2761 silver badge10 bronze badges

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

1 Comment

Michael Dorner Over a year ago

Thanks for your solution. I really hoped there is a built-in method to do this. I cannot imaging that this an uncommon intention, isn't it?

Danon · Accepted Answer · 2020-01-31 10:13:09Z

4

Here's is an actual code (built-in):

from datetime import datetime, timezone, timedelta

return datetime(yy, mm, dd, hh, min, ss, 0, timezone(timedelta(hours=5)))       # +0500
# or
return datetime(yy, mm, dd, hh, min, ss, 0, timezone(timedelta(seconds=18000))) # +0500

answered Jan 31, 2020 at 10:13

Danon

3,00731 silver badges42 bronze badges

Comments

Michael Dorner · Accepted Answer · 2021-11-18 11:54:45Z

3

I believe .astimezone() is what you want.

from datetime import datetime, timezone
d = datetime.strptime("2013-03-21T14:19:42+0100", "%Y-%m-%dT%H:%M:%S%z") # 2013-03-21 14:19:42+01:00
d.astimezone(timezone.utc) # 2013-03-21 13:19:42+00:00

timezone.utc is not an optional parameter in this case: The documentation says

If called without arguments (or with tz=None) the system local timezone is assumed for the target timezone.

This can lead to unintended behaviour (depending on your local timezone).

edited Nov 18, 2021 at 11:54

Michael Dorner

20.6k16 gold badges96 silver badges132 bronze badges

answered Nov 17, 2021 at 21:16

0xc0de

8,3575 gold badges52 silver badges78 bronze badges

3 Comments

Michael Dorner Over a year ago

It depends: Documentation says "If called without arguments (or with tz=None) the system local timezone is assumed for the target timezone." Maybe you can add to your answer:

from datetime import datetime, timezone\n d = datetime.strptime("2013-03-21T14:19:42+0100", "%Y-%m-%dT%H:%M:%S%z")\n d.astimezone(timezone.utc)

Michael Dorner Over a year ago

Sorry I edited the answer myself. :)

0xc0de Over a year ago

@MichaelDorner Yes, you are correct, thanks!

Collectives™ on Stack Overflow

Apply timezone offset to datetime in Python

3 Answers 3

1 Comment

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related