Date Format in QlikView

[#1]

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

[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]

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

;