Oracle date如何比较大小分析

sql代码


复制代码 代码如下:

— created on 2010/04/17 by nan

declare

— local variables here

i integer;

v_date1 date;

v_date2 date;

begin

— test statements here

v_date1 := sysdate;

v_date2 := to_date( ‘2008-09-08’);

if v_date1 > v_date2 then

dbms_output.put_line( ‘if’);

else

dbms_output.put_line( ‘else’);

end if;

end;