Skip to Content
0
Jul 05, 2012 at 01:51 PM

how to convert a day number in to date format....

13 Views

Hi friends,

I am using the Oracle DB for my webi report in the DB date field is storing it as number(3) i.e., 161 is in DB level i have to convert it and show it in report as '06/09/2012' eg 162 ==> '06/10/2012' i have to show in this format in report level 'dd-MMM-YYYY'

can u guide how to convert it into date format. it willbe helpfull to me ..

BOE: XIR2

OracleDB

WEBI REPORT

Thanks &Regards,

Ravi Sarma,

9699318299