runtime error on sql script
574741Aug 30 2008 — edited Aug 30 2008Hi
i have a filed start_time in table has NUMBER(38).the number is in seconds format. I am converting this into HH24:MI:SS filed.
in sql, i have statement like this:
to_char(to_date(start_time,'sssss'),'hh24:mi:ss')
when i run script i am getting error ORA-01853: seconds in day must be between 0 and 86399
I think when start_time exceeds 24:00:00 time period. it is giving error. 1 days = 60*60*24=86400
If it is bellow 23:59:59 it is working fine. How can i get to run this script evern if start time is more than 24 hours.
pl help.
thx, M.