Datetime
超過 15 分鐘的 Informix
如何在 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