sql server,时间比较一般就是下面这种形式:
select * from table where time<'2006-09-12 00:00:00'
MySql和sql server一样
Oracle:
select * from oracletable where time<to_date('2006-09-12 00:00:00','yyyy-mm-dd hh24:mi:ss')
几个日期比较的SQL语句
最新推荐文章于 2023-10-24 15:50:03 发布
sql server,时间比较一般就是下面这种形式:
select * from table where time<'2006-09-12 00:00:00'
MySql和sql server一样
Oracle:
select * from oracletable where time<to_date('2006-09-12 00:00:00','yyyy-mm-dd hh24:mi:ss')