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

3 votes259 views4 answers
Mysql decimal
SQL
1 vote264 views1 answer
Jooq convert using gbk
SQL
0 vote264 views1 answer
Android sqlite add column if not exists
SQL
7 votes312 views1 answer
Show line number in sql server
SQL
2 votes262 views3 answers
Mysql list tables by size
SQL
0 vote241 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote259 views1 answer
Using GROUP BY in MySQL Join Table
SQL
2 votes263 views1 answer
How to make insert script from table in SQL server
SQL
0 vote270 views1 answer
How to move a column to different spot mysql
SQL
0 vote256 views1 answer
Sql server python connection
SQL