datetime - How to convert UTC time pulled from an API into local time using Python?

Question

I currently have a field I'm pulling from an API called "categorized-at" that has this format:

"23/7/2020"

However, this API uses UTC+0000 time, but we need this to be in -0600 time. We submitted a ticket to the place that hosts the API asking for help and they were unable to assist us. However, I've made good process and have this chunk of code:

from datetime import datetime, timezone, timedelta
import time
from dateutil import tz

from_zone = tz.tzutc()
to_zone = tz.tzlocal()
utc = datetime.strptime('23/7/2020', '%d/%m/%Y')
utc = utc.replace(tzinfo=from_zone)
central = utc.astimezone(to_zone)

This works perfectly, but only if I include a specific date in the parameter of datetime.strptime - however, this needs to be applied to the "categorized_at" field for a report with thousands of values that needs to be automated. I tried to just include "categorized_at" in there like this:

utc = datetime.strptime('categorized_at', '%d/%m/%Y')

but no matter how I try and adjust the date formatting, I get the error

'time data "categorized at' does not match '%d/%m/%Y'

I feel like the solution here is something simple I'm overlooking, and any help would be appreciated.

question from:https://stackoverflow.com/questions/65832961/how-to-convert-utc-time-pulled-from-an-api-into-local-time-using-python

Answer 1

Waitting for answers