ALTER TABLE TBSERVIDOR
    ADD NOME VARCHAR(50),
    ADD IP VARCHAR(50);

UPDATE TBSERVIDOR S SET S.nome = lower(S.descricao), S.ip = '192.168.0.179';

SET TERM ^ ;

create or alter function FORMATDATETIME_PONTO (
    CAMPO timestamp)
returns timestamp
AS
BEGIN
 RETURN cast( (
            lpad(EXTRACT(YEAR   FROM Campo) ,4,'0') ||'-'||
            lpad(EXTRACT(MONTH  FROM Campo) ,2,'0') ||'-'||
            lpad(EXTRACT(day    FROM Campo) ,2,'0') ||' '||
            lpad(EXTRACT(hour   FROM Campo) ,2,'0') ||':'||
            lpad(EXTRACT(minute FROM Campo) ,2,'0') ||':00'
        ) as timestamp);
END
^

SET TERM ; ^
