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

2 votes228 views2 answers
Mysql write into table
SQL
0 vote194 views1 answer
How to locate pg_hba.conf file
SQL
0 vote188 views1 answer
Left join vs inner join performance
SQL
0 vote194 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote189 views1 answer
Sql orcale i forgot what my name & password was
SQL
1 vote228 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote181 views1 answer
How to find username and password in oracle 18c
SQL
0 vote196 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote166 views3 answers
Mysql calculate age from date of birth
SQL
1 vote202 views1 answer
Sql server kill all connections
SQL