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 vote208 views1 answer
Repeatable read trong sql server
SQL
1 vote192 views1 answer
Change table to innodb mysql
SQL
4 votes174 views1 answer
Sql any
SQL
0 vote200 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
1 vote185 views2 answers
How to search date in sql query
SQL
3 votes176 views1 answer
Oracle list user grants
SQL
1 vote202 views1 answer
Select from describe sql
SQL
1 vote182 views1 answer
Alter add syntax
SQL
11 votes188 views4 answers
Update row in mysql
SQL
0 vote176 views1 answer
Mysql default timestamp value to be current timestamp
SQL