topic Date Format issue in QlikView

Date Format issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Date Format issue

Anil_Babu_Samineni — Tue, 25 Apr 2017 05:52:53 GMT

This should work direct, No need any changes. Can you send whole script what you have done

Re: Date Format issue

Anonymous — Tue, 25 Apr 2017 05:56:01 GMT

NEW_TABLE:

LOAD

ISSUE_ID

,CREATED

;

SQL SELECT

ISSUE_ID

,CREATED

FROM ISSUETABLE;

Re: Date Format issue

tresB — Tue, 25 Apr 2017 06:01:29 GMT

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.