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
day:hh:mi:ss format.

when i run this query
select to_char(to_date(chk_time),'sssss'),'hh24:mi:ss') from dual;
i got his error.

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.