Oracle Common SQL Time functions

1. Query the current date and time

Select  from dual;

2. Check the last day of this month

Select  from dual;

3. How many months before and after query

Select add_months (sysdate, from dual;

4. Check the specific date of the week of the following week (Sunday-Saturday: 1-7)

Select next_day (sysdate,1 from dual;

5, Time to turn time

Select to_char (sysdate,'yyyy-mm-dd HH:MI:SS' from dual;

6. Character Turn time

Select to_date ('20160101','yyyy-mm-dd ' from dual;

7. The date of the inquiry is specific to the day of the week

Select to_char (to_date ('2016-01-01','yyyy-mm-dd' ),'day' from dual;

8, the difference between the query days

Select  Floor - to_date ('20000101','yyyymmdd '  from dual;

Oracle Common SQL Time functions