Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using the oracle query. what date format qlikview accept?
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
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
;