日期和字符转换函数用法(to_date,to_char)
select to_char(sysdate,'YYYY-MM-DD hh24:mi:ss') as nowTime from dual; --日期转化为字符串
select to_date('2018-11-26 22:10:20','YYYY-MM-DD hh24:mi:ss') as nowDateTime from dual; -- 字符串日期时间转date格式日期时间
select to_char(sysdate,'YYYY') as nowYear from dual; --获取当前的年份
select to_char(sysdate,'MM') as nowMonth from dual; --获取当前的月份
select to_char(sysdate,'DD') as nowDay from dual; --获取当前的日期
select to_char(sysdate,'hh24') as nowHour from dual; --获取当前的小时
select to_char(sysdate,'mi') as nowMinute from dual; --获取当前的分钟
select to_char(sysdate,'ss') as nowSecond from dual; --获取当前的秒钟
获取周几
select to_char(sysdate,'day') from dual; --获取当前周几
select to_char(to_date('2018-11-27','YYYY-MM-DD'),'day') from dual; --获取指定日期为周几
select to_char(sysdate,'day','NLS_DATE_LANGUAGE = English') from dual; --获取当前周几(英语)
当前时间之前(之后)
--当前时间减去10分钟的时间 (十分钟前)
select sysdate,sysdate - interval '10' MINUTE FROM dual;
--当前时间加上10分钟的时间 (十分钟后)
select sysdate,sysdate + interval '10' MINUTE FROM dual;
--当前时间之前某段时间 (括号内可选参数 分别为分钟 小时 天 月 年 )
select sysdate,sysdate - interval '10' (MINUTE,HOUR,DAY,MONTH,YEAR) FROM dual;