Question

Ive this statement:

create table times (time_in timestamp, time_out timestamp);
insert into times values(to_timestamp( 02-MAY-11 07.57.00.000000 AM ), to_timestamp( 02-MAY-11 07.30.00.000000 PM ));
select extract(hour from(time_out-time_in))|| : ||extract(minute from(time_out-time_in)) from times;

EXTRACT(HOURFROM(TIME_OUT-TIME_IN))|| : ||EXTRACT(MINUTEFROM(TIME_OUT-TIME_IN))   
--------------------------------------------------------------------------------- 
11:33

现在,大麻与上述结果比较。例如:IF [result] > [8个小时] TheN ...

如何做到这一点?

Answer 1

SELECT *
FROM times
WHERE time_out - time_in > interval  8  hour

在一项PL/SQL程序之外,这样做是为了:

declare
  result interval day to second;
begin

  -- !!! make sure this select returns only one row, or use a cursor !!!
  select time_out - time_in 
     into result
  from times; 

  if (result > interval  8  hour) then
    dbms_output.put_line( greater );
  end if;
end;
/

友情链接