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 vote350 views1 answer
Sql datediff db2
SQL
16 votes361 views2 answers
Oracle ddl
SQL
-1 vote379 views3 answers
How to restart mysql in linux
SQL
0 vote365 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
5 votes375 views1 answer
Mysql count newlines in field
SQL
3 votes360 views2 answers
WhereIn SQL
SQL
1 vote382 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
0 vote377 views1 answer
Oracle query archive mode
SQL
0 vote333 views1 answer
Oracle create package body
SQL
1 vote378 views1 answer
Avg mysql
SQL