Hi,

i have one hard coded time which will be 23:45 and one will be sysdate (same date) and time less than 23:45.

i want to start my job at 23:45 and the input file will be arriving before that. so i want to make sure that the task starts only at 23:45 and from the input file time till 23:45 the script should go into sleep mode.

for that i need difference between both the times in seconds so that i can use sleep for the difference time.

Please help me on how to get the difference in seconds.

Any other solution to achieve the same requirement is also welcomed.