获取当前时间
select to_char(sysdate,'yyyy-mm-dd') as ppp from dual //获取当前时间
select to_char(sysdate,'yyyy') as ppp from dual // 获取当前年份
select to_char(sysdate,'mm') as ppp from dual //获取当前月份
select to_char(sysdate,'dd') as ppp from dual // 获取当前天数
select last_day(add_months(SYSDATE,-1 )) FROM dual//获取上个月的最后一天
select last_day(add_months(SYSDATE,-2 )) +1 FROM dual //上个月的第一天
select to_char(trunc(sysdate,'MONTH'),'yyyy-mm-dd') First_DayOfMonth from dual //获取本月的第一天
select to_char (last_day(trunc(sysdate,'MONTH')),'yyyy-mm-dd') Last_DayOfMonth from dual //获取本月的最后一天
第一次写暂时写这点 后续再加吧