CREATE OR ALTER PROCEDURE BDATE_TIME(
DT TIMESTAMP)
RETURNS (
RESULT VARCHAR(16))
AS
begin
--извлекаем день
SELECT l.result||'.' FROM lpad(extract(day FROM :dt),2,'0') l INTO result;
--извлекаем месяц
SELECT :result||l.result||'.' FROM lpad(extract(month FROM :dt),2,'0') l INTO result;
--извлекаем год
SELECT :result||l.result||' ' FROM lpad(extract(year FROM :dt),4,'0') l INTO result;
--извлекаем час
SELECT :result||l.result||':' FROM lpad(extract(hour FROM :dt),2,'0') l INTO result;
--извлекаем минута
SELECT :result||l.result FROM lpad(extract(minute FROM :dt),2,'0') l INTO result;
--result = '00.00.0000 00:00';
suspend;
end