Return to Answer

15 minutes is spelled with 2 digits :) — capitalize keywords to edit more than 6 characters

Source Link

edit approved Mar 13, 2017 at 16:15

selectSELECT type, channel, teilnr, starttime, endtime, usedtime, host 
fromFROM online_time 
whereWHERE starttime > (CURRENT - 515 UNITS MINUTE) 
orderORDER byBY starttime descDESC

select type, channel, teilnr, starttime, endtime, usedtime, host 
from online_time 
where starttime > (CURRENT - 5 UNITS MINUTE) 
order by starttime desc

SELECT type, channel, teilnr, starttime, endtime, usedtime, host 
FROM online_time 
WHERE starttime > (CURRENT - 15 UNITS MINUTE) 
ORDER BY starttime DESC

Source Link

created Mar 13, 2017 at 15:52

LStrike

select type, channel, teilnr, starttime, endtime, usedtime, host 
from online_time 
where starttime > (CURRENT - 5 UNITS MINUTE) 
order by starttime desc