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

1 vote235 views1 answer
Postgresql blocked on mac
SQL
-1 vote218 views5 answers
Operator in sql
SQL
11 votes217 views2 answers
How to import mysql database command line
SQL
-1 vote211 views2 answers
Postgresql get last 10 records
SQL
3 votes203 views3 answers
Stop mysql ubuntu
SQL
0 vote215 views3 answers
Duplicate row mysql
SQL
0 vote293 views1 answer
How to find sql server name
SQL
1 vote203 views1 answer
Postgresql substring last
SQL
50 votes315 views6 answers
Sql count duplicate rows
SQL
1 vote210 views2 answers
Copy database mysql
SQL