topic iso date format in QlikView

iso date format

userid128223 — Tue, 23 May 2017 20:41:40 GMT

I am trying to read data via HTTP call:

Orignal Data:

Date: "2017-05-19T13:43:40.200Z"

However when it comes into qlikview i get below.

2017-05-19 13:43:40

How can i get orignal format.

Query is called via SQl.

Table:

SQL Select

Date

from JSON(wrap off) .........

Anil_Babu_Samineni — Wed, 24 May 2017 02:41:29 GMT

Just use Date# function in Qlikview like below and it will deserve the issue

Date#(DateFieldName) as DateFieldName

userid128223 — Wed, 24 May 2017 03:12:32 GMT

It is comming in wrong from SQL statement hence Load statement wont correct anything.

Digvijay_Singh — Wed, 24 May 2017 04:09:34 GMT

You may use Dual to make it to desired format, like below, may not work exactly but just an idea -

Load Dual(Left(Date,10)&'T'&mid(Date,12,8)&'.000Z',Date) as Date;

Load Date inline [

Date

2017-05-19 13:43:40 ];

Anil_Babu_Samineni — Wed, 24 May 2017 04:28:56 GMT

Can you share the script for Date where you fetch from DB. Can you show case exactly the values as you are getting

I assume, you may need here

Table:

Load Date#(Date) as Date;

SQL Select

Date

from JSON(wrap off) .........