Oracle 日期函数
select sysdate from dual;
select to_date( sysdate) from dual;
select to_char( sysdate, 'yyyy' ) from dual;
select to_char( sysdate, 'yy' ) from dual;
select to_char( sysdate, 'yyy' ) from dual;
select to_char( sysdate, 'mm' ) from dual;
select to_char( sysdate, 'mon' ) from dual;
select to_char( sysdate, 'month' ) from dual;
select to_char( sysdate, 'dd' ) from dual;
select to_char( sysdate, 'ddd' ) from dual;
select to_char( sysdate, 'dy' ) from dual;
select to_char( sysdate, 'day' ) from dual;
select to_char( sysdate, 'hh' ) from dual;
select to_char( sysdate, 'hh24' ) from dual;
select to_char( sysdate, 'mi' ) from dual;
select to_char( sysdate, 'ss' ) from dual;
select to_char( sysdate, 'Q' ) from dual;
select to_char( sysdate, 'WW' ) from dual;
select to_char( sysdate, 'W' ) from dual;
时间练习,使用到的emp表请登陆scott用户。
select to_char( to_date( '2018-08-02' , 'yyyy-mm-dd' ) , 'day' ) from dual;
select floor( sysdate- to_date( '20190908' , 'yyyymmdd' ) ) from dual;
select next_day( to_char( sysdate) , 'TUESDAY' ) from dual;
SELECT MONTHS_BETWEEN
( TO_DATE( '02-02-1995' , 'mm-dd-yyyy' ) ,
TO_DATE( '01-01-1995' , 'mm-dd-yyyy' ) ) "Months"
FROM DUAL;
select floor( sysdate- e. hiredate) from emp e;
select sysdate+ 1 from dual;
select months_between( sysdate, e. hiredate) from emp e;
select months_between( sysdate, e. hiredate) / 12 from emp e;
select floor( ( sysdate- e. hiredate) / 7 ) from emp e;
select
floor( to_date( '1990-02-04' , 'yyyy-dd-mm' ) - e. hiredate) fried
from emp e;