Subject | Dialect 1 Date type casting problem |
---|---|
Author | willy_metra |
Post date | 2006-05-12T10:33:33Z |
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!
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!