Loading dates from Oracle

[Anonymous]

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 ?

[MayilVahanan]

HI

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