topic Re: Oracle char date inQlikview in QlikView

Oracle char date inQlikview

jood_ahmad — Sun, 19 Feb 2017 06:56:03 GMT

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 ,

Anil_Babu_Samineni — Sun, 19 Feb 2017 07:19:43 GMT

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

vinieme12 — Sun, 19 Feb 2017 07:20:25 GMT

use to_date() in your SQL statement

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 — Sun, 19 Feb 2017 21:22:48 GMT

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