select sysdate from dual;--2018/10/30 8:54:51
select trunc(sysdate) from dual; --2018/10/30
select to_char(trunc(sysdate)) from dual; --30-OCT-18
select to_char(sysdate,'yyyymmdd') from dual;--20181030
sql中日期操作
最新推荐文章于 2021-12-19 17:49:05 发布
select sysdate from dual;--2018/10/30 8:54:51
select trunc(sysdate) from dual; --2018/10/30
select to_char(trunc(sysdate)) from dual; --30-OCT-18
select to_char(sysdate,'yyyymmdd') from dual;--20181030