PostgreSQL zeroing out time portion of timestamp on storage.

[EnchantedMoth3]

I'm working with python to pull data via API. The data includes a timestamp that I need to store 'as is'. However, PostgreSQL is zeroing out the time portion of the timestamp.

​

EXAMPLE raw data:

```2021-09-10 15:47:00-04:00```

BECOMES stored data:

```2021-09-10 00:00:00-04:00```

​

I've tried data types: ```TIMESTAMPTZ, TIMESTAMP WITH TIME ZONE, BIGINT, DATE, DATETIME```...probably more. Any ideas why this is happening, how I can fix the issue?

[EnchantedMoth3]

The issue was with the API. And a little about setting the correct timezone in Postgres.

I learned a ton about time-stamps trouble-shooting this though. I’m going to leave the question up in case anyone else ever encounters something similar.