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 vote250 views1 answer
Kimball data warehouse sql calendar
SQL
5 votes206 views1 answer
Oracle list functions
SQL
1 vote238 views1 answer
Insert many to many sql
SQL
13 votes192 views5 answers
Oracle list tables
SQL
1 vote208 views2 answers
Find nth highest salary of an employee
SQL
3 votes232 views3 answers
Create table in SQL Server
SQL
12 votes192 views1 answer
Env var for setting password for root user mysql docker hub
SQL
1 vote197 views1 answer
Postgres regex remove special characters
SQL
0 vote211 views1 answer
Groupby error in mysql
SQL
1 vote222 views1 answer
Postgresql substring last
SQL