| 21. 10. 1. Working with dates and built-in functions EXTRACT |
|
|
EXTRACT function takes a single part of a date/interval/timestamp (year only, month only, and so on, up to the second). |
|
v_nr:= EXTRACT (TYPE from DATE|TIMESTAMP|INTERVAL value);
|
|
EXTRACT always returns a numeric value. |
If you need the text name of the month, you should use TO_CHAR. |
The possible types you can pass into EXTRACT are YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND. |
You can also use time zone types with timestamps. |
|
SQL>
SQL> declare
2 v_nr number;
3 begin
4 v_nr:=EXTRACT(MONTH from sysdate);
5 DBMS_OUTPUT.put_line(v_nr);
6 end;
7 /
6
PL/SQL procedure successfully completed.
SQL>
|
|