如何写SQL从一个表里，获取最近两个月的数据记录

[zhuxianjun1]

表结构：
表名：A
字段1：worker_name (char)
字段2: worker_date (date)

请问：如何写SQL从一个表里，获取最近两个月的数据记录

[areswang]

months_between()

[cosio]

select * from A where worker_date<=sysdate-60

要注意日期的格式

[caoleione]

select * from A where worker_date between ADD_MONTHs(sysdate,-2) and sysdate;

[范佩西_11]

[Quote=引用 3 楼 caoleione 的回复:]
select * from A where worker_date between ADD_MONTHs(sysdate,-2) and sysdate;
[/Quote]
正解

[ximizhi]

[Quote=引用 3 楼 caoleione 的回复:]
select * from A where worker_date between ADD_MONTHs(sysdate,-2) and sysdate;
[/Quote]

正解！

[seasir123]

select * from A where worker_date <=sysdate-60
天数不一定搞对

ADD_MONTHs(sysdate,-2) 函数准确
3楼正解

[wycg_cnh20]

select * from A where worker_date between ADD_MONTHs(sysdate,-2) and sysdate;
正解