DateTime

jennytan — Fri, 28 May 2021 07:08:13 GMT

Hi,

I am extracting a field of data type datetime from a SQL database but when it is displayed, it shows the date is 8 hours behind the actual date and time.

For other fields which are defined as date, the dates are displayed correctly.

What could be the possible reason for this and how can I fix it?

Kindly assist.

Thanks.

e.g.

Extracted Value

Actual value

topic DateTime in QlikView

DateTime