Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vinieme12
Champion II
Champion II

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


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.....