modernsky2003

oracle打印输出结果

   set serveroutput on
    declare
dbegin date;
dend date;
begin
dbegin:=to_date('2008-04-16 00:00:00','yyyy-mm-dd hh24:mi:ss');
dend:=to_date('2008-04-16 23:59:59','yyyy-mm-dd hh24:mi:ss');
dbms_output.put_line((dend-dbegin)*24*60*60);
end;

posted on 2008-04-18 11:03  hekeneng  阅读(4575)  评论(0编辑  收藏  举报

导航