iso date format

[userid128223]

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]

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

Date#(DateFieldName) as DateFieldName

[userid128223]

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

[Digvijay_Singh]

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]

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) .........