Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
stonecold111
Creator III
Creator III
‎2017-05-18 10:01 AM

Date format problem

Hi Qlikss,

We are using oracle database. but in report it only fetching date part only.

but i want it in timestamp format. why it is not taking timestmp format from source

suggest me.

NVL(OL.DATE,OL.FUL_DATE) as date,

1,550 Views
0 Likes
10 Replies
avinashelite
MVP
MVP
‎2017-05-19 01:37 AM

In response to stonecold111

Your try to convert the time format in the SQL? the check the format how its stored in the DB and convert accordingly

160 Views