Oracle日期转换函数获取年份、月、日、当年最后一天年初第一天，查看当前登录的用户的表:

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;