Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 209 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Convert number to hh24:mi:ss
2985260
Rank 2 - Community Beginner
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.
0
Answers
-
Its not converting. It shows the same 1000
0 -
Hi,
what means not working?
do you see an error or Comes up the wrong datetime,...?
regards Hendrik
0 -
0
-
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.
0