20220904作業

原始的だけどこういうので良いんだよ。

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’;

コメント