DIAVIS-wiki
[[GraphicalStorytelling/データベース操作]] :Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff| :Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff|ex. select * from items where date > '2006-11-25 12:00:00.0' order by date desc *BETWEEN条件 [#je925709] 値が指定した2つの値の間にあるか否かを比較. SELECT * FROM Orders WHERE CustomerID = 'QUICK' AND OrderDate BETWEEN '1996/1/1' AND '1997/12/31' ex. select * from items where date BETWEEN '2006-11-25 12:00:00.0' AND '2006-11-25 15:00:00.0' order by date desc *参考 [#yc591cf8] :@IT 連載:SQL実践講座(1)|http://www.atmarkit.co.jp/fnetwork/rensai/sql01/sql1.html#4 |