In oracle, the month or part of data is obtained from the specified date. The oracle date

In oracle, the month or part of data is obtained from the specified date. The oracle date

Obtain part of the data from the specified date:

Such as month:

Select to_CHAR (sysdate, 'mm') from dual;

Or:

Select extract (month from sysdate) from dual;

Or the most stupid method, use to_char () to first convert the date to a string in the specified format, and get the desired data through substr.

Select substr (to_char (sysdate, 'yyyy-mm-dd'), 6, 2) from dual;

Obtain other data of the date in the same way as the previous method.

How does one obtain the year in the date in oracle?

Select to_char (field, 'yyyy') from table name;
For example:
Select to_char (accpttime, 'yyyy') from corinfo;

Example: how to obtain the month in the Date Field in SQL (under oracle)

Select to_char (date column, 'mm') as month from Table Name