|
SQL>
SQL> DECLARE
2 v_college_deadline TIMESTAMP;
3 BEGIN
4 v_college_deadline := TO_TIMESTAMP('06/06/2004', 'DD/MM/YYYY')
5 + INTERVAL '12-3' YEAR TO MONTH
6 + INTERVAL '19 9:0:0.0' DAY TO SECOND;
7
8 DBMS_OUTPUT.PUT_LINE('My daughter leaves for college in '
9 ||v_college_deadline);
10 END;
11 /
My daughter leaves for college in 25-SEP-16 09.00.00.000000 AM
PL/SQL procedure successfully completed.
SQL>
SQL>
|