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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Format in QlikView

I am using the oracle query. what date format qlikview accept?

2 Replies
sunny_talwar

QlikView should be able to load in any date format. In case it is unable to read a specific date as date you can force it to understand it using Date#() function

Date#(DateField, 'DateField's Date Format') as Date

Best,

Sunny

maxgro
MVP
MVP

first try without any format / interpretation function

ie in my environment I get a Qlik timestamp from an Oracle date (DAY_DATE) without any interpretation function

SQL SELECT

DAY_DATE

FROM TEST.TEST

;