select sysdate,add_months(sysdate,-12),to_char(trunc(add_months(sysdate,-12)),'yyyy-mm-dd')||' 00:00:00' from dual;
Oracle中取前六个月的日期sql
最新推荐文章于 2023-01-30 16:25:46 发布
select sysdate,add_months(sysdate,-12),to_char(trunc(add_months(sysdate,-12)),'yyyy-mm-dd')||' 00:00:00' from dual;