Dev Corner » Blog Archive » Get year,month, day Part from Date in Oralce PL/SQL
To extract date parts in PL/SQL you can use the TO_CHAR function. For example, you can get the month number from a date value with the following expression TO_CHAR(date_value, 'mm');. There is better approach. You can use the EXTRACT function to get the ....