convert seconds to HH:MI:SS for large numbers
I have a column name chk_time number(38).
It is recorded in seconds. I need to view in DAY:HH:MI:SS format or
HH:Mi:SS format. MY most of the numbers are larger, I think i need
when i run this query
i got his error.
select to_char(to_date(chk_time),'sssss'),'hh24:mi:ss') from dual;
ORA-01830: date format picture ends before converting entire input string
if chk_time is smaller number the same query works. if it is a larger number like 876543298 it is not working. how to solve this pl help. thx,N.