Postgres format date in select

select pg_catalog.concat(current_date,' 00:00:00')::timestamp /*Formata hora por exemplo no where*/

and plan_signed_at = TO_CHAR(created_at, 'YYYY-mm-dd')::timestamp /*Formata hora por exemplo no where um é date, o outro datetime*/

select  NOW() - INTERVAL '180' MINUTE /*pega a data e hora com 3 horas menos*/

select to_char(NOW(), 'yyyy/MM/dd HH24:MI:SS') AS date_no_tz, NOW() as date_tz /*data formatada com e sem timezone*/

Similar codes

0 vote212 views1 answer
Extract sql from query object sqlalchemy
SQL
16 votes197 views3 answers
Order by sql query
SQL
0 vote241 views2 answers
How to truncate all table in mysql workbench
SQL
-1 vote217 views1 answer
Mac mysql workbench console
SQL
0 vote229 views1 answer
Remove transient options sql wordpress
SQL
0 vote236 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
4 votes227 views1 answer
W3schools create table
SQL
0 vote221 views1 answer
Mysql DDL
SQL
19 votes241 views3 answers
How to change column type psql
SQL
1 vote216 views2 answers
List tables sqlalchemy
SQL