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 vote223 views1 answer
Postgress append string in select
SQL
3 votes225 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote220 views1 answer
Sql select column names starting with
SQL
0 vote268 views1 answer
Psql create usr
SQL
1 vote225 views1 answer
Mariadb case switch
SQL
2 votes219 views1 answer
Oracle list grants on procedure
SQL
1 vote247 views1 answer
Trim leading zeros in sql
SQL
0 vote242 views1 answer
Add a new column into table
SQL
12 votes252 views4 answers
How to check mysql version ubuntu
SQL
1 vote214 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL