php - Mysql using only a time in date_sub or alternative -


i have mysql field set "time", , check against time, using time well.

i have cron run every 10 minutes, clients can set reminder messages sent out every day @ time of day or so.

using following query not give me fields last 9 minutes:

select `id` `sms_reminders` (`option` = "weekdays" or `option_days` "%4%") , `time` < date_sub(now(), interval 9 minute) 

however, giving me mixed results.

my time field set @ 09:50:00 (time of running query 09:53:00).

thanks.

make few changes in code use > instead of <


Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -