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 vote143 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
1 vote218 views1 answer
Adding a check statement in sql
SQL
0 vote140 views1 answer
How to order result of subquery in select
SQL
2 votes154 views1 answer
Oracle drop sequence if exists
SQL
0 vote160 views1 answer
Delete a record from a table sqlite3
SQL
0 vote143 views1 answer
Get duplicate entry sql
SQL
0 vote153 views1 answer
Sql update subtract value
SQL
0 vote193 views1 answer
Doctors appointment
SQL
0 vote144 views1 answer
Oracle db timestamp auto add
SQL
2 votes181 views2 answers
Mysql search for column name in all tables
SQL