求助:informix 如何算得两个时间之间的差的,秒数和!

bystreetboy

informix 如何算得两个时间之间的差的,秒数和!

计算current year to second 与时间1970-01-01 00:00:00 之间相差的秒数!
谢谢!

liaosnet

额。。。直接减。。。

bystreetboy

select (current year to second - datetime(2007-01-01 00:00:00) year to second ) from config;

(expression)

      690 11:15:18

得出这样的结果!
那么是不是可以直接
把这个数值进行计算,求出秒数之和

或者可以用 interval 来计算出秒数之差吗?

谢谢

bystreetboy

这个是我写的 procedure

create procedure UNIX_TIMESTAMP2(v_date varchar(20))
returning  int;
--define cmp_datetime varchar(19);

--if  v_date<='1970-01-01 00:00:00' then
--return 0;
--end if;
define st_datetime datetime year to second;
define cmp_datetime datetime year to second;
define v_return varchar(20);
define i_return int;
let st_datetime = datetime(1970-01-01 00:00:00)  year to second ;
let cmp_datetime = to_date(v_date,'%Y-%m-%d %H:%M:%S');
let v_return = cmp_datetime - st_datetime;
let i_return = (substr(v_return,1,length(v_return) - 9)*86400 + substr(v_return,-2)*1 + substr(v_return,-5,2)*60 + substr(v_return,-8,2)*3600)::integer;
let i_return = i_return - 8*3600;
return  i_return;
end procedure ;

select UNIX_TIMESTAMP('2008-11-21 23:59:59') from test_sub;
(expression)

  1227283199
谢谢!