- 论坛徽章:
- 0
|
Oracle8i 的日期函数
set serveroutput on
Declare
Months Number;
Days Number;
Hours Number;
Minutes Number;
Seconds Number;
Diff Number:=&Dif ;
Diff0 Number;
Diff1 Number;
Diff2 Number;
Begin
Days:=FLOOR(Diff);
Diff0:=Mod(Diff,1);
dbms_output.put_line ( 'Days - '||Days||' Mod is '||Diff0);
Hours:=FLOOR(Diff0*24);
Diff1:=Mod(Diff0*24,1);
dbms_output.put_line ( 'Hours - '||Hours||' Mod 1 is '||Diff1);
Minutes:=FLOOR(Diff1*60);
Diff2:=MOD(Diff1*60,1);
Seconds:=Floor(Diff2*60);
dbms_output.put_line ( 'Minutes - '||Minutes||' Seconds - '||Seconds);
dbms_output.put_line ( 'Minutes - '||Minutes||' Seconds - '||Seconds);
end;
/ |
|