Date format problem

[stonecold111]

Hi Qlikss,

We are using oracle database. but in report it only fetching date part only.

but i want it in timestamp format. why it is not taking timestmp format from source

suggest me.

NVL(OL.DATE,OL.FUL_DATE) as date,

[avinashelite]

Your try to convert the time format in the SQL? the check the format how its stored in the DB and convert accordingly