Hello Thomas,
Monday, December 03, 2001, 8:01:45 PM, you wrote:
>> How can i get time interval only in minutes or in seconds ?
>> For example i have '1 month 15 days' and i need these time in
>> minutes.
TL> lockhart=# select extract(epoch from interval '1 month 15 days') / 60;
TL> ?column?
TL> ----------
TL> 64800
TL> (1 row)
Oh...thanks one more question.
I create these function:
CREATE FUNCTION sum_revenue() RETURNS real AS '
DECLARE
call RECORD;
BEGIN
tmpsum := 0;
FOR call IN SELECT
country,(date_part('epoch), starttime - endtime)::float AS seconds ,type from calls where sub_acc = 4
LOOP
RETURN call.minutes;
END LOOP;
end;
' LANGUAGE 'plpgsql';
And in call.minutes i've got '0';
Why ? How can i retrive call.minutes ?
these RETURN only for debug.
TL> - Thomas
------------
With respect,
Yuri A. Kabaenkov
hellman@artofit.com