Datetime

超過 15 分鐘的 Informix

  • March 13, 2017

如何在 IBM Informix 中執行此 MySQL 語句?

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

我在 Informix 中嘗試了這個,但它給出了語法錯誤。

select type, channel, teilnr, starttime, endtime, usedtime, host 
from online_time 
where starttime < subdate(CURRENT, INTERVAL "15" MINUTES)
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 

引用自:https://dba.stackexchange.com/questions/167017