| Subject | How do I get the differences between 2 timestamps as a timestamp. |
|---|---|
| Author | cornievs |
| Post date | 2013-06-04T00:01:02Z |
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
...
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