Convert number to hh24:mi:ss

2985260

Summary

Convert number to hh24:mi:ss

Content

I have a field which has seconds in number format. I have to convert it into hh24:mi:ss. For example select to_char(to_date(10000,'SSSSS'),'hh24:mi:ss') num_time from dual; gives time as 02:46:40. Now i want to do this rtf template. I tried <?xdofx:to_char(to_date(10000,'sssss'),'hh24:mi:ss')?>, but this is not working. Can anyone has idea how to convert.

Thanks,
Rakesh.

2985260

Its not converting. It shows the same 1000

Hendrik Schmidt

Hi,

what means not working?

do you see an error or Comes up the wrong datetime,...?

regards Hendrik

Hendrik Schmidt

Hi,

I think following can help:

( https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=11jtifhlsv_9&_afrLoop=440145479496041 )

+

Extended Function Support in RTF Templates

regards

YGUTTIKONDA

for BI Publisher the date should be in Canonical  format like  ‘YYYY-MM-DD’ or ‘YYYY-MM-DDTHH:MI:SS’ format. create the column in your SQL query , so the data is already formatted per requirement.