|
SQL> create or replace procedure p_split (i_date_dt DATE,
2 o_hour IN OUT NUMBER, o_min IN OUT NUMBER)
3 is
4 begin
5 DBMS_OUTPUT.put_line(o_hour||'/'||o_min);
6 o_hour:=to_NUMBER(to_char(i_date_dt,'hh24'));
7 o_min :=to_char(i_date_dt,'mi');
8 DBMS_OUTPUT.put_line(o_hour||'/'||o_min);
9 end;
10 /
Procedure created.
SQL>
SQL>
SQL> declare
2 v_hour NUMBER:=12;
3 v_min NUMBER:=20;
4 begin
5 p_split(sysdate, v_hour, v_min);
6 DBMS_OUTPUT.put_line (
7 'Total minutes:'||(v_hour*60+v_min));
8 end;
9 /
12/20
21/27
Total minutes:1287
PL/SQL procedure successfully completed.
SQL>
|