Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) .........
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 [
Date
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
Table:
Load Date#(Date) as Date;
SQL Select
Date
from JSON(wrap off) .........