Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the breadcrumb-navxt domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/devtools/public_html/blog/wp-includes/functions.php on line 6131
{"id":511,"date":"2011-11-03T07:35:00","date_gmt":"2011-11-03T10:35:00","guid":{"rendered":"https:\/\/devtools.com.br\/blog\/funcao-para-formatar-data-no-postgresql\/"},"modified":"2022-08-01T08:01:21","modified_gmt":"2022-08-01T11:01:21","slug":"funcao-para-formatar-data-no-postgresql","status":"publish","type":"post","link":"https:\/\/devtools.com.br\/blog\/funcao-para-formatar-data-no-postgresql\/","title":{"rendered":"Fun\u00e7\u00e3o para Formatar Data no PostgreSQL"},"content":{"rendered":"\n

Dando sequencia ao assunto formata\u00e7\u00e3o de datas, qual j\u00e1 abordei anteriormente no MySQL<\/a>, hoje veremos no PostgreSQL.<\/p>\n\n\n\n

Ent\u00e3o, vamos \u00e0 fun\u00e7\u00e3o:<\/p>\n\n\n\n

 CREATE OR REPLACE FUNCTION \"paposql\".\"fun_converte_data\" (  \n  \"p_data\" timestamptz\n )  \n RETURNS varchar AS  \n $body$  \n DECLARE  \n l_ret   varchar  ;  \n BEGIN  \n l_ret := (to_char(p_data,'dd\/MM\/yyyy HH24:MI:SS'));  \n return l_ret;  \n END;  \n $body$  \n LANGUAGE 'plpgsql'  \n VOLATILE  \n CALLED ON NULL INPUT  \n SECURITY INVOKER  \n COST 100;  \n<\/code><\/pre>\n\n\n\n
A fun\u00e7\u00e3o tem como par\u00e2metro de entrada um timestamptz, representado aqui pelo p_data.<\/p>\n\n\n\n
Com o par\u00e2metro fornecido, converto a data para o formato Dia, M\u00eas, Ano, Hora, Minuto, Segundo atrav\u00e9s da fun\u00e7\u00e3o to_char alimentando a vari\u00e1vel l_ret, ap\u00f3s retorno a vari\u00e1vel com a informa\u00e7\u00e3o, simples n\u00e3o!<\/p>\n\n\n\n
<\/p>\n\n\n\n
\n