cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

convert date time field to UTC format

lak
7 - Data Storage
7 - Data Storage

Hello,
I need some help around converting the date field column.
I have a Customer response table coming from Redshift. The date time field is originally stored in UTC format.But when pulling it into Sisense, it is displaying in local timezone.
I wanted it to be displayed in the same UTC format as that in the original database.
 
For ex:  I have a column response_date, with the date in the backend DB as 
2023-08-11 22:09:56.86+00 , but when it comes to Sisense its displaying as : 8/11/2023, 03:09 PM ( which is in local timezone)

How to restore to the original UTC time format.

1 REPLY 1

rapidbisupport
9 - Travel Pro
9 - Travel Pro

Hi Iak,

Is your instance self-hosted or Sisense Cloud?

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email community@sisense.com