系统要oracle和sqlserver都要兼容,但是oracle时间段查询的时候,需要用to_date函数,
系统底层怎么写才能兼容呢?
sqlserver
select * from student where stime>'2012-01-12'
oracle
select * from student where stime>to_date('2012-01-12')
系统底层怎么写才能兼容呢?
sqlserver
select * from student where stime>'2012-01-12'
oracle
select * from student where stime>to_date('2012-01-12')
不过强求oracle和sqlserver兼容,可能会出现很多问题
pst.setDate(1,日期型数据)