SQL, convert integer for Timestamp subtraction

Viewed 594

Assume we have a relation R(A, B), with A contains int values and B contains Timestamps.

We have to calculate: (time in B in minutes) - (int to minutes).

Example: (125, "2017-06-01 16:23:00")

16:23:00 = 983 min
125 = 125min

983 - 125 = 858min

The elements of A represent minutes, my problem is to convert an integer value >59 to hh:mm, since MAKETIME(hh, mm, ss) only works in the range 0 to 59.

1 Answers
Related