[Minute-second function for getting system time in Oracle], oracle minute-second function

[Minute-second function for getting system time in Oracle], oracle minute-second function

1. Get the year of the current system time

Select to_char (sysdate, 'yyyy') from dual; -- year

2. Obtain the month of the current system time.
Select to_char (sysdate, 'mm') from dual; -- month

3. Get the date of the current system time.
Select to_char (sysdate, 'dd') from dual; -- day

4. Obtain the quarter of the current system time.

Select to_char (sysdate, 'q') from dual; -- quarter

5. Obtain the number of weeks of the current system time (52 or 53 weeks per year based on the calendar type)

Select to_char (sysdate, 'iw') from dual; -- week --

Format Date:

TO_CHAR (SYSDATE (), 'yy/MM/DD HH24: MI: SS)

Or TO_DATE (SYSDATE (), 'yy/MM/DD HH24: MI: SS)

Select to_char (sysdate, 'yyyy-MM-dd HH24: mi: ss') from dual;

Select to_char (sysdate, 'yyyy-MM-dd HH24: mm: ss') from dual;

Select to_char (sysdate, 'yy-mm-dd hh24: mi: ss') from dual

Select to_date ('2017-12-25 14:23:31 ', 'yyyy-mm-dd, hh24: mi: ss') from dual