Hi! I’m trying to get the date and time at which the dataset was refresh at, to do that I created a column in a Redshift query using getdate() command. The preview of the dataset in quicksight query editor shows the correct date and time but when I try to use it in the analysis it removes the time and shows it as 00:00:00, could that be a bug?
Hello @zpawe,
Welcome to QuickSight Community!
Can you tell us a little more about how are you using the timestamp from Redshift into your analysis? e.g. are you using it on a calculated field or just trying to display it?
I just quickly tried displaying the value from a TIMESTAMP column coming from Redshift and woks as expected.
Kind regards,
Andres.
I kept my aggregation as DAY by mistake, thanks a lot - it was hard to notice with the new UI.