Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Facing Date format issue!
below are Oracle DB Dates as Follows
2017-03-21 10:14:59
2017-03-21 10:18:43
2017-03-21 10:30:32
2017-03-21 10:32:09
2017-03-21 10:32:24
2017-03-21 10:37:07
2017-03-21 10:35:04
2017-03-21 10:35:25
2017-04-12 21:57:03
2017-04-12 21:51:51
after loading into qlikview i am getting like below format
plz find attached Word
This should work direct, No need any changes. Can you send whole script what you have done
NEW_TABLE:
LOAD
ISSUE_ID
,CREATED
;
SQL SELECT
ISSUE_ID
,CREATED
FROM ISSUETABLE;
Try like:
If the similar approach doesn't work for you, it could be because QV is not reading it they way you see the date in the DB. You may read : Why don’t my dates work? And also can try to load the date field as-it-is from the DB and check in the front-end listbox how it comes, then go back to the script and read it accordingly using date(date#()) function.