Here is an example that uses date functions. The following query selects all rows with a date_col value from within the last 30 days: mysql> SELECT something FROM tbl_name -> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;
select * from table(select *,rowid as rn from birth_user 生日 order by desc) as birth_user where rn<5oracle語法
-> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;