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 vote290 views1 answer
Get all employee of salary if more than in sql
SQL
38 votes281 views4 answers
Count sql
SQL
5 votes300 views4 answers
Upload database mysql command line
SQL
0 vote289 views1 answer
Edit shchima table in sql
SQL
3 votes274 views1 answer
Oracle apex call duration
SQL
0 vote274 views1 answer
Nth max in my sql
SQL
0 vote265 views1 answer
SQL get max per id
SQL
13 votes292 views6 answers
Mysql remove duplicates
SQL
0 vote288 views1 answer
Set root password mysql xampp
SQL
0 vote284 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL