select to_number(sysdate-to_date('1970-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))*24*60*60*1000 from dual;
--毫秒值转日期
select to_char((1523476222000/1000/60/60/24+to_date('1970-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS')),'YYYY-MM-DD HH24:MI:SS') from dual;
--获取当前日期
select sysdate from dual;
--获取某月的最后一天
select last_day(to_date('2017-04','YYYY-MM')) from dual;
--获取上个月的最后一天
select to_char(last_day(add_months(sysdate,-1)),'YYYY-MM-DD') from dual;
--获取今天是本周第几天,周日为第一天
select to_char(sysdate,'d') from dual;
--获取上个周一
select to_char(sysdate+(2-to_char(sysdate,'d'))-7,'YYYY-MM-DD') from dual;或select trunc(sysdate,'iw')-7 from dual;或select to_char(next_day(sysdate,'星期一')-7) from dual;
--获取上周日
select to_char(sysdate+(2-to_char(sysdate,'d'))-1,'YYYY-MM-DD') from dual;或select trunc(sysdate,'iw')-1 from dual;或select to_char(next_day(sysdate,'星期日')-7) from dual;
--获取年
select to_char(sysdate,'YYYY') from dual;
--获取月份
select to_char(sysdate,'MM') from dual;
--获取天
select to_char(sysdate,'DD') from dual;