Hi,
I have a program to calculate attendance details of employees.
Here i compute unpaid minutes between each punches.
For eg. Suppose if an employee is absent from 09:00 am to 09:45 am, then the unpaid minutes would be 45.
But if f an employee is absent from 09:14 am to 09:31 am, then also unpaid minutes would be 45
Here the unpaid minutes calculation is as follows.
from time is always rounded backward to 15 minutes. totime is always rounded forward to 15 minutes, then
modified fromtime and to time would be 09:00 am and 9:45 am
How can i do that in oracle procedure where i have two date variables fromtime and totime.
I want to get modified fromtime and totime
Please help
I use oracle 10g