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