oracle:
select * from a where time> to_date('1990-09-23','yyyy-mm-dd');
sql server:
select * from a where time> cast('1990-09-23' as datetime);
或者
select * from a where time> convert(datetime,'1990-09-23');
select * from a where time> to_date('1990-09-23','yyyy-mm-dd');
sql server:
select * from a where time> cast('1990-09-23' as datetime);
或者
select * from a where time> convert(datetime,'1990-09-23');
select * from a where time> '#1990-09-23#';
select * from a where time> '1990-09-23'
日期时间转移成字符串,用: to_char(sysdate,'YYYY-MM-DD HH24:MI:SS')