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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jood_ahmad
Creator II
Creator II

Oracle char date inQlikview

Dear how can I convert the Oracle Cahr date to qlikview data I have the below format:

02-JAN-2017 14:00:00

any idea ,

3 Replies
Anil_Babu_Samineni

Simple Date function will work in Qlikview. To_Char() is the Data base function. Here can you tell me which format you want to see

Date(FieldName, 'DD-MM-YYYY')

This will give as per your date -- 02-01-2017

Check the follow

https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vinieme12
Champion III
Champion III

use  to_date() in your SQL statement

Oracle TO_DATE: See Oracle TO_DATE () Function from ETL perspective !!

or in Qlikview Load statement try as below

DATE(DATE#('02-JAN-2017 14:00:00','DD-MMM-YYYY hh:mm:ss'),'TheFormatYouWantToStoreAs') as DATEField


Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
maxgro
MVP
MVP

At the Oracle side, if you have an Oracle char field

select to_date( '02-JAN-2017 14:00:00', 'DD-MON-YYYY HH24:MI:SS',  'NLS_DATE_LANGUAGE = American' )

from dual

replace '02-JAN-2017 14:00:00' with your field

and dual with your table

maybe you don't need the third parameter, NLS_DATE.....