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 vote324 views1 answer
Flask sqlalchemy decimal
SQL
0 vote363 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote388 views1 answer
Delete from IN subquery
SQL
2 votes339 views5 answers
SQL trigger
SQL
1 vote322 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote329 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
5 votes322 views1 answer
Migrate sql table another database
SQL
2 votes342 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote345 views1 answer
Sql get highest date from 3 tabels
SQL
1 vote335 views1 answer
How to select rows with no matching entry in another table?
SQL