1. 日期格式化字符串(to_char)
获取系统当前时间,按照一定的格式字符串输出
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual;
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;
2. 字符串和时间互转
select to_date('2020-05-07 13:23:44','yyyy-mm-dd hh24:mi:ss') from dual;
3、日期转int类型
to_number(to_char(sysdate,'yyyy')),
4.求某天是星期几
select to_char(to_date('2020-05-26','yyyy-mm-dd'),'day') from dual;
5、 两个日期间的天数
select floor(sysdate - to_date('20200405','yyyymmdd')) from dual;
6.一年的第几天
select TO_CHAR(SYSDATE,'DDD'),sysdate from dual
7、当年年初第一天
select trunc(sysdate,'yyyy') from dual;
8、次年年初第一天
select add_months(trunc(sysdate,'yyyy'),12) from dual;
9、查看当前登录的用户的表:
select table_name from user_tables;