Exercise · SQL & Querying
Predict, then run it
Predict the output
sess(a, b) = 23:59 → 00:01 next day. The session's real length is elapsed minutes, not nights crossed:
SELECT date_diff('minute', a, b) AS mins FROM sess;Predict the exact output.
sess(a, b) = 23:59 → 00:01 next day. The session's real length is elapsed minutes, not nights crossed:
SELECT date_diff('minute', a, b) AS mins FROM sess;Predict the exact output.