Question

oracle中date类型转换和比较大小

一个date类型的数据，取比'2012-04-26'大的数据

Answer 1

to_date或者to_char
to_date方法如 c6iz 的回答
to_char方法为
to_char(date字段,'yyyy-mm-dd')>'2012-04-26'

Answer 2

使用 to_date('2012-04-26','YYYY-MM-DD')
例如：
select created from user_objects where created > to_date('2012-04-26','YYYY-MM-DD');

CREATED
---------
10-MAY-12
10-MAY-12
05-JUN-12
05-JUN-12
05-JUN-12

Answer 3

select * from xxx where to_char(datename,yyyy-mm-dd)>'2012-04-26'