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 vote151 views1 answer
Copy Table from SQL to CSV
SQL
0 vote158 views1 answer
Convert .mdf to .bak
SQL
18 votes153 views3 answers
Find column name in database
SQL
-1 vote189 views1 answer
How to Activate the database
SQL
0 vote151 views1 answer
Pl/sql loop example
SQL
3 votes192 views2 answers
How to modify rows in SQL Server
SQL
7 votes191 views4 answers
Mysql delete older duplicates
SQL
11 votes155 views2 answers
Insert current date sql
SQL
0 vote168 views1 answer
Postgres list all triggers
SQL
0 vote157 views1 answer
T-sql update table variale
SQL