Display single calendar day on US East timezone?

[duncan]

Hello @conoroneillsb , welcome to the QuickSight community!

I think your best bet if the timezone feature in QuickSight is not working is doing this in SQL during ingestion from Prostgres. You can use CustomSQL when creating a new dataset.

I would also check out this post:

Automatic TimeZone Conversion Not Working Correctly

We have a report running off a RDS database where the timestamps are in UTC but the data type is “TIMESTAMP WITHOUT TIMEZONE”. When we try and apply Quicksight automatic time zone adjustment, the adjustment is in the wrong “direction”. I.e. given the below times in UTC: [image] We would expect that upon changing the timezone to “Paris” that in the above report “9:16:38” would be adjusted to “11:16:38”, instead, as shown below, the time is adjusted backwards and becomes “7:16:38”. [image] Thi…