I need to do a calculation in my Select statement. The calculation is
((((1 + sysdate() - "job-dt-start") * 86400) +
systime() - "job-tm-start" - 86400) / 86400)
in the above my job-tm-start is the time, its in integer and stored as seconds.
but the systime is in HH:MM:SS format. how to convert it to seconds.