Oracle
使用to_date函数实现
select * from t_user t where t.birthday> to_date('2007-07-06','yyyy-mm-dd');
MySQL
用date_format函数进行比较
select * from t_user t where t.birthday> to_date('2007-07-06','%Y-%m-%d');
Oracle
使用to_date函数实现
select * from t_user t where t.birthday> to_date('2007-07-06','yyyy-mm-dd');
MySQL
用date_format函数进行比较
select * from t_user t where t.birthday> to_date('2007-07-06','%Y-%m-%d');