Minute of the respond time (SQL)

Question

I'm stuck with a minute function. At first i used days_between ( "Created Time", "Locked Time") to check on the responded time in day but know i wish to change to Minutes instead of Days.

and your code is where? What have you got, what have you tried? — Trent, Jul 05 '22 at 06:05

score 4 · Answer 1 · answered Jul 05 '22 at 06:06

4

Assuming locked time is the later time, you would use:

timestampdiff(minute, created_time, locked_time)

to get the difference in minutes.

answered Jul 05 '22 at 06:06

ysth

96,171
6
121
214

Minute of the respond time (SQL)

1 Answers1