SQL語句日期的處理
<br />查詢數據庫表中日期之間的記錄時,可以這樣寫SQL語句:<br />select * from 表 where time between '2009-7-27 00:00:00' and '2009-8-1 23:59:59'<br /><br /><br />select * from 表 where time between '2009-7-27' and '2009-8-1' 如果這樣的話,則不包括2009-8-1