Date column in Redshift table, becomes timestamp in Quick Sight Dataset

Q&A
,
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 Quick Sight Community !

When importing date columns from Redshift into Quick Sight, 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 Quick Sight 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

1 Like
3

Hi @mamgain,

Following up here as it’s been awhile since last communication took place on this thread; did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!