topic Re: Character Field convert to date format in QlikView

Character Field convert to date format

upaliwije — Thu, 14 Aug 2014 22:51:54 GMT

Dear Friends

My following date is stored as a character field in oracle table. How can I convert into date format in Load script

Pls help me

07-MAR-13

maxgro — Thu, 14 Aug 2014 23:13:33 GMT

if you have a char use date#

date#('07-MAR-13', 'DD-MMM-YYYY')

in script

load

...,

date#(YOURCHARFIELD, 'DD-MMM-YYYY') as NewDate,

...

;

SQL

select

.....

YOURCHARFIELD,

....

from

YOURORACLETABLE;

jagan — Fri, 15 Aug 2014 02:58:42 GMT

Hi,

Try like this

In Qlikview

LOAD

Date(Date#(DateFieldName, 'DD-MMM-YYYY'), 'MM/DD/YYYY') AS FormattedDate

FROM DataSource;

In Oracle

SELECT

To_char(DateFieldName, 'MM/DD/YYYY') AS FormattedDate

FROM TableName;

Hope this helps you.

Regards,

Jagan.