Subject Dialect 1 Date type casting problem
Author willy_metra
Hello,

i would like to ask someone kind for a help in writing stored procedure
part, where i want to get delay rounded to seconds as a output result
of:

Inputs:
TotalTime DATE (date + time present)
StartTime DATE (date + time present)
DurationTime DATE (only time part present)

Output:
Delay INTEGER (estimated delay in seconds)

Delay = TotalTime - (StartTime + DurationTime)

Thank you for any kind help!