Convert number to hh24:mi:ss

Question

Summary

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.

YGUTTIKONDA · Answer

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.

Hendrik Schmidt · Answer

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

2985260 · Answer

Its not converting. It shows the same 1000