select * from leadlogin WHERE
to_date(ZJDRSJ,‘yyyy-MM-dd HH:mi:ss’)>trunc(sysdate)-30 ORDER BY ZJDRSJ DESC
这是sql
select * from 表名WHERE
to_date(字段名,‘格式’)>trunc(sysdate)-30(时间) ORDER BY ZJDRSJ DESC
select * from leadlogin ORDER BY to_number(DRCS)