Posted on 2011-11-07 11:56
Kevin Meng 閱讀(259)
評論(0) 編輯 收藏
字段為Datetime，獲得2011-11-05以后添加的記錄
SELECT * FROM geo_corporation t WHERE TO_DAYS(t.addtime)>TO_DAYS('2011-11-05')
某一時間段內的記錄
SELECT * FROM geo_corporation t WHERE TO_DAYS(t.addtime)>TO_DAYS('2011-11-05') AND TO_DAYS(t.addtime)<TO_DAYS('2011-11-7')