mysql比較時間

select * from operatlog where date_format(optime, '%Y-%m-%d') > '2007-01-01' and date_format(optime, '%Y-%m-%d') < '2009-01-01' limit 1;

本文出自“lbk90032190”