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

1 vote137 views1 answer
Postgresql update auto_increment value
SQL
16 votes133 views1 answer
CTE statement sql server
SQL
0 vote140 views1 answer
Sql output select
SQL
0 vote124 views1 answer
Sql case sttement with set
SQL
1 vote121 views1 answer
Alphabetical order mysql
SQL
0 vote131 views1 answer
Sql period overlap
SQL
1 vote123 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote133 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote117 views1 answer
Convert rows to columns in sql server
SQL
0 vote120 views1 answer
Sql make sure every user is unqiuew
SQL