原始的だけどこういうので良いんだよ。
DROP FUNCTION ADD_TIME( TEXT,Integer);
CREATE FUNCTION ADD_TIME( ad_time TEXT,ad_count Integer ) RETURNS INTEGER AS ‘
DECLARE
ln_cntval INTEGER;
BEGIN
SELECT
LPAD(cast((cast(substring(ad_time,1,2) as integer)*60 + cast(substring(ad_time,4,2) as integer) + ad_count)/60 as text),2,”0”)||
LPAD(cast((cast(substring(ad_time,1,2) as integer)*60 + cast(substring(ad_time,4,2) as integer) + ad_count)%60 as text),2,”0”)
INTO ln_cntval;
return ln_cntval;
END;
‘ LANGUAGE ‘plpgsql’;
コメント