8 Replies Latest reply on Mar 26, 2020 12:55 PM by Don Wise

    Time and Date different between 2 columns.

    Kyle Dinh

      Hi folks,

      Can someone explain to me how to calculate the difference between two-time points?

      Let's say I have a table from the SQL server that has columns that are showing the date/time of an event:  EventID, EventStartDate, EventEndDate, EventStartTime, EventEndTime.

      Now I would like to know how long did events happen, EventDurationDay = EventEndDate - EventStartDate, EventDurationMinuter = EventEndTime - EventStartTime.