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 vote168 views1 answer
Drop df constraint sql server
SQL
0 vote177 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
2 votes199 views1 answer
Sql count having
SQL
0 vote164 views1 answer
Like sql for second letter of the family name
SQL
3 votes174 views1 answer
Oracle user privileges
SQL
0 vote178 views2 answers
Sql 2 way of select unique
SQL
0 vote395 views1 answer
Sql datum formatieren
SQL
0 vote225 views1 answer
Drop view sql
SQL
1 vote164 views1 answer
Crontab every month
SQL
7 votes160 views3 answers
Sql get last inserted row
SQL