Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

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>