When connected to Amazon Redshift, you want to combine a DATE column and a TIME column and convert them into a TIMESTAMP data type.
Because Tableau does not natively support the database TIME data type and Amazon Redshift does not support a direct CAST from TIME to TIMESTAMP, simply concatenating or casting these columns can result in errors such as:
"ERROR: cannot cast type time without time zone to timestamp without time zone".
To resolve this issue, use one of the following options.
MAKEDATETIME([date_column], [time_column])
SELECT CAST(date_column || ' ' || time_column AS TIMESTAMP) AS date_time_cast FROM your_table
Alternatively:
SELECT (date_column + time_column) AS date_time_cast FROM your_table
For more information on separating time from a Date & Time field, see the following article:
Isolate Time from Date and Time Field
Please note that, as described in the following article, you cannot use TIME data type columns in Tableau Desktop directly via drag-and-drop:
Fields with TIME Data Type Not Imported Into Tableau Desktop for MS SQL Server
005393489