The PVR backend (as the server side part), which directly communicates with a TV tuner adapter(s) to receive the Live TV signals and create a video or audio stream, and also record to files.
1. Convert time between hour, minute, second, or day with conversion factor. As we known, 1 hour = 60 minutes = 3600 seconds =1/24 day. So we can convert the time measurement with multiplying these factors. Convert between hours to seconds:
The column test_time is of data type DATE, too, it also must not be converted further. To get the DATEdifference you have only to calculate test_time-SYSDATE This difference of two DATE values gives the number of days. Therefore you have to multiply the above value by 1440 (=24*60, the number of minutes per day).