I have the following table (Staff_Events) ... Start_Date TIMESTAMP, End_Date TIMESTAMP, Period TIMESTAMP, ....
and need to set Period to the time difference between End_Date and Start_Date. End_Date will always be later than Start_Date. (Enforce by on Insert/Update triggers.) I know I can the get difference with DATEDIFF, but I need the result as a TimeStamp. I would appreciate any help. Regards Cornie van Schoor