topic Re: Teradata Timestamp with Timezone to QlikView in QlikView

Teradata Timestamp with Timezone to QlikView

manideep78 — Mon, 15 Feb 2021 21:51:38 GMT

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 — Tue, 16 Feb 2021 15:18:20 GMT

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