Date timestamp not showing in dashboard table

[radhkan]

I am creating a dataset with customer sql to get columns including a date column which comes as timestamp in the dataset (syntax is CONVERT_TIMEZONE(‘UTC’, ‘Asia/Kolkata’, ls.latest_inbound_date) as latest_inbound_date_ist,). However when i add the column in the dashboard table, the column is always showing in Date, even after changing the custom format to DD/MM/YYYY HH24:MI:SS.

Is it the default setting in quicksight or any other way to get the timestamp

[Xclipse]

Hi @radhkan

Welcome to the Quick Suite community!

You may find it useful to review the following Quick Suite community post where a similar issue has already been discussed.

TimeStamp not showing hour, minute, second

Hello there, I am re-oppening this case because I am having the same problem and I was not able to solve it… I have a field in my dataset called “creation_date” which is in timestamp format: [image] When I add it to a table in Quick Sight analysis it does not give me the hour:minute information, even if I customise the date format to do so: [image] Could you please help me understand what is the cause of this issue? Thanks in advance!

[radhkan]

I don’t know the cause of the issue, even i am looking for the solution

[Xclipse]

Hi @radhkan

Can you provide the more details about the error/issue and share the screenshot?

[radhkan]

I am running the below syntax to get the values as below

CONVERT_TIMEZONE(‘UTC’, ‘Asia/Kolkata’, ls.latest_inbound_date) as latest_inbound_date_ist,

CONVERT_TIMEZONE(‘UTC’, ‘Asia/Kolkata’, ls.dm_updated_dt) as Refresh_Date_Time

But when i add this to dashboard table as columns i don’t see the timestamp though i formatted the column to MM/DD/YYYY HH24:MI:SS. I tried multiple custom format, but not getting the timestamp in the dashboard table.

Table

Query output in dataset

[Xclipse]

Hi @radhkan

You can format the datetime field to display the time (HH:MM:SS) along with the date.

Customizing date formats in Quick Suite - Amazon Quick Suite

[parmisa]

Hi @radhkan Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 3 days, we will archive the question.

Thanks

[WLS-Luis]

Hi @radhkan,

Since we haven’t received any further updates from you, I’ll treat this inquiry as complete for now. However, if you have any additional questions, please feel free to create a new post in the community and link this discussion for context.

Thank you!