Date Format issue

[Anonymous]

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

[Anil_Babu_Samineni]

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

[Anonymous]

NEW_TABLE:

LOAD

       ISSUE_ID

      ,CREATED

          ;

SQL SELECT

   ISSUE_ID

  ,CREATED

  FROM  ISSUETABLE;

[tresesco]

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.