The year, month, and day Field Values for the oracle date. The oracle Field

The year, month, and day Field Values for the oracle date. The oracle Field

Address: http://yanwushu.sinaapp.com/oracle_extract_year_month_day_valu/

Previously, we used to_char (timeField, 'yyyy') to obtain the year field value in the date. This method is definitely inefficient. In order to write more standardized and reasonable SQL statements, use the following method to obtain the year, month, day, hour, minute, and second values of the date field in the database.

Select extract (year of timeFieldName) from tableName; // Date: year

Select extract (month of timeFieldName) from tableName; // month