DB2:
SELECT * FROM table WHERE time BETWEEN TIMESTAMP('2011-5-10 8:00:00') AND TIMESTAMP('2011-5-20 8:00:00')
SQLSERVER:
SELECT * FROM table WHERE time BETWEEN CONVERT(DATETIME,'2011-5-10 8:00:00') AND CONVERT(DATETIME,'2011-5-20 8:00:00')
ORACLE:
SELECT * FROM table WHERE time BETWEEN TO_DATE('2011-5-10 8:00:00','yyyy-mm-dd hh24:mi:ss') AND TO_DATE('2011-5-20 8:00:00','yyyy-mm-dd hh24:mi:ss')
三种数据库中的时间类型函数例子
最新推荐文章于 2022-11-30 17:25:46 发布