Oracle date year, month, and day field values

Original address: http://yanwushu.sinaapp.com/oracle_extract_year_month_day_valu/

Previously, the To_char (Timefield, ' YYYY ') method was used to get the year field value in the date. The efficiency of this method is certainly not high, in order to write more standardized, more reasonable SQL, should use the following way to get the date field in the database year, month, day, time, minute, second equivalent.

Select Extract (Year of timefieldname) from TableName; Date taken year

Select Extract (month of timefieldname) from TableName; Take the Month

Oracle date year, month, and day field values