Teradata Timestamp with Timezone to QlikView

[manideep78]

Dear Community,

Can you please let me know how to read this kind of date format in QlikView. I have used different date formats but nothing worked.

Read the date as is and display in QlikView.

BTW, these date are coming out of Teradata. 

I have connected Teradata  and QlikView using ODBC and reading the date columns.

[QFabian]

Hi @manideep78 , please try creating a new field like this :

LOd

fields..

DateField,

date#(substring(DateField, ' ', 1))  as DateField2 

From yoursource;

Is going to separate the date using space as separator for the subfield function.

Just take care of the date separator '/', can be replaced for '-' if needed, but with Date# function should be work