In my postgres Database, i have a column with type : TIME.
Since Quicksight doesn’t support this type, what is the best way to deal with this type of data ?
and is there any way to use it as X or Y axis in my analysis/dashboard or to use agregate functions on that
Hi @ilyasse
Can you please try the following approach, concatenate the date and time fields in the backend PostgreSQL database. You can then change the date aggregation to hours, minutes, and seconds in Quick Sight.
Example : (Syntax may vary)
SELECT (current_date + time_column) AS time_with_date
FROM your_table;
Thank you it’s working now 
