I am trying to read data via HTTP call:
However when it comes into qlikview i get below.
How can i get orignal format.
Query is called via SQl.
from JSON(wrap off) .........
Just use Date# function in Qlikview like below and it will deserve the issue
Date#(DateFieldName) as DateFieldName
It is comming in wrong from SQL statement hence Load statement wont correct anything.
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 [
2017-05-19 13:43:40 ];
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
Load Date#(Date) as Date;
Retrieving data ...