Python Script Keeps Converting Dates To Utc

I have the following: import psycopg2 from openpyxl import Workbook wb = Workbook() wb.active =0 ws = wb.active ws.title = 'Repair' ws.sheet_properties.tabColor = 'CCFFCC' print(w

Solution 1:

just in case anybody runs into something like this in the future... I found the problem if you add the following to the query

 `at time zone 'America/Chicago'

it will resolve the problem. Somehow the at time zone UTC is not enough you still need to specify the output timezone