I am trying to convert a weird format string timestamp to a datetime. This is what it looks like:
04.05.2003 00:00:00.000 GMT+0100
I am trying something like this, but it’s not matching. I think I am just missing the expression for that GMT offset at the end.
datetime.datetime.strptime('04.05.2003 00:00:00.000 GMT+0100','%d.%m.%Y HH:MM.SS.sss')
Of course it spits out the format error
ValueError: time data '04.05.2003 00:00:00.000 GMT+0100' does not match format '%d.%m.%Y HH:MM.SS.sss'
What is the format string I need to use here?
>Solution :
You need format operators for the time, not HH:MM:SS, and you need a format operator for the timezone. The operator for a timezone offset is %z.
datetime.datetime.strptime('04.05.2003 00:00:00.000 GMT+0100','%d.%m.%Y %h:%M:%s.%f GMT%z')