Category "timestamp-with-timezone"

AthenaQueryError: Athena query failed: "NOT_SUPPORTED: Unsupported Hive type

I recently ran into the following error "AthenaQueryError: Athena query failed: "NOT_SUPPORTED: Unsupported Hive type", and for this I followed this stack overf

How do I extract a date (dd-mm-yy) from a timestamp with timezone (timestamptz) in postgresql

My date column "timestamp" is currently listed as: 2020-11-16 20:27:38.033 +0000 It's formatted as timestamptz and I've tried every search on here and google to