Loading dates from Oracle

Anonymous — Thu, 25 Jul 2013 20:04:06 GMT

I have a coloumn in a oracle table as data.

I need to have the column into the qlikview seperated as day , month , year , hour , minute

Can i have this loaded seperated in the load ?

Re: Loading dates from Oracle

MayilVahanan — Thu, 25 Jul 2013 20:07:26 GMT

Try like this

Load

day(DateField) as Day,

month(DateField) as month,

Year(DateField) as Year,

Hour(DateField) as Hour,

Minute(DateField) as Minute,

Select * from tablename;

Use preceding load, it helps

Hope it helps