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 vote255 views2 answers
Sqlalchemy default value for column
SQL
2 votes210 views1 answer
Python sql
SQL
1 vote173 views2 answers
Sql multiline comment
SQL
0 vote159 views2 answers
Azure sql-datenbank
SQL
0 vote175 views1 answer
How to declare variable date in mysql
SQL
0 vote153 views1 answer
Rabbitmq service not starting
SQL
0 vote170 views1 answer
Timestamp(0) postgresql
SQL
0 vote191 views1 answer
The fetch keyword oracle
SQL
0 vote179 views1 answer
TSQL convert csv to table
SQL
0 vote186 views3 answers
How to assign custom id in mysql
SQL