Date column in Redshift table, becomes timestamp in Quicksight Dataset

Question & Answer
,
1

Hi All,

I have a date column in redshift Table, and whenever I import it into the Dataset it becomes timestamp adding trailing “00:00:000“ automatically.

Now once I use it in any analysis, the csv export shows timestamps even if I change the format in UI to date.

How can i fix this?

Thank you!

2

Hello Abhishek,

Firstly, Welcome to the QuickSight Community !

When importing date columns from Redshift into QuickSight, the system often converts them to timestamp format with trailing zeros (00:00:00). If i am not mistaken, This is a known behavior in QuickSight when handling date fields.

To fix this issue when exporting to CSV, you can create a new calculated field using the formatDate function with the formula: formatDate({your_original_date_column}, ‘yyyy-MM-dd’).

This new field will be a string type containing only the date in the YYYY-MM-DD format without the time component.

See reference here - Can't Find "Edit Date Format" in Dataset - #3 by toddc

Hope this helps.

Cheers,

Deep