猜猜每条SQL是干啥的?
select to_char(trunc(add_months(last_day(to_date('2015-09-02','yyyy-mm-dd')), -1) + 1), 'yyyy-mm-dd') from dual
select trunc(sysdate, 'yyyy') from dual;
select trunc(sysdate,'year')-1+ 0.99999 from ...
原创
2019-10-28 13:47:22 ·
162 阅读 ·
0 评论