Python date string conversion fail

Question

I am trying to convert the following string '1.12.22 14:16UTC+01:00' in Pandas to December 1st 2022

my_date = '1.12.22 14:16UTC+01:00'
new_date = pd.to_datetime(my_date)

Timestamp('2022-01-12 14:16:00-0100', tz='pytz.FixedOffset(-60)')

It inverts month with day only in specific cases. I am trying to use format="%d.%m.%Y %H:%M%z" but it says that the string is not matching the format.

time data '1.12.22 14:16UTC+01:00' does not match format '%d.%m.%Y %H:%M%z' (match)

Thanks for your help.

Check the docs docs.python.org/3/library/… %z doesn't work as you expect. — alec_djinn
– alec_djinn, Commented Nov 24, 2022 at 9:59

tangolin · Accepted Answer · 2022-11-24 10:03:40Z

2

>>> pd.to_datetime('01.12.22 14:16UTC', format='%d.%m.%y %H:%M%Z')
Timestamp('2022-12-01 14:16:00+0000', tz='UTC')

I am not sure if this is what you are looking for, but your placeholders are wrong, check this page to know what they stand for.

answered Nov 24, 2022 at 10:03

tangolin

4831 gold badge5 silver badges22 bronze badges

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

Comments

Oleg · Accepted Answer · 2022-11-24 09:59:21Z

1

have you tried adding a zero?

my_date = '01.12.22 14:16UTC+01:00'

answered Nov 24, 2022 at 9:59

Oleg

534 bronze badges

Collectives™ on Stack Overflow

Python date string conversion fail

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related