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 vote192 views1 answer
Nth max in my sql
SQL
4 votes198 views4 answers
Oracle tablespace tables list
SQL
0 vote200 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
2 votes231 views1 answer
Oracle insert or update
SQL
0 vote206 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
2 votes196 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote182 views2 answers
Get top 1 row of each group
SQL
2 votes218 views1 answer
Sql string_agg
SQL
0 vote188 views1 answer
Create bakupd database sqlserver
SQL
0 vote180 views1 answer
Mysql group rows with same value
SQL