Working with postgres timestamptz column

Q&A
, , , , ,
1

Although postgres timestamp columns are natively supported, it appears that timestamptz columns are not supported by Quicksight. Interestingly, I have a timestamptz column and I can view the column contents in the DataSet editor and use it in a calculated field, but if I try to consume that column in a Quick Sight visualization, the visualization only displays an error “Your function expression contains an unsupported date. Correct the date format and try again.” Is there any way that Quicksight can work with the timestamptz column or will I need to wrap postgres table in a view that converts the date time to a different format without the timezone information?

2

Yes you will need to convert it to a supported date format for quicksight.

I can mark the addition of timestamptz to be supported as a feature request.