I need help with a query to get the amount of minutes from DATETIME
So I have a column called "signupdate" that is a datetime datatype. And I want to be able to get the elapsed time it took between signups of a user with the same ip address. I never formulated datetime datatypes before, can anyone offer any assistance?
SELECT (FORMULA TO GET ELAPSED TIME [HIGHEST VAL - LOWEST VAL])
WHERE ipaddress = "10.10.1.100"
Basically to do this and output 6 minutes:
22:26:16 - 22:20:01 = 6:15
I'm getting stuck on how to get the highest value and lowest value from the 5 rows of data
"Things you can get access to, you should never memorize." -Albert Einstein
"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin