1

How can I do this MySQL statement in an IBM Informix?

select type, channel, teilnr, starttime, endtime, usedtime, host 
from online_time 
where starttime < DATE_SUB(NOW(),INTERVAL 15 MINUTE)
order by starttime desc 

I tried this one in Informix, but it gave a syntax error.

select type, channel, teilnr, starttime, endtime, usedtime, host 
from online_time 
where starttime < subdate(CURRENT, INTERVAL "15" MINUTES)
order by starttime desc 
1
2
SELECT type, channel, teilnr, starttime, endtime, usedtime, host 
FROM online_time 
WHERE starttime > (CURRENT - 15 UNITS MINUTE) 
ORDER BY starttime DESC 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.