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 vote128 views1 answer
Sum sqlserver
SQL
15 votes290 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote139 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
1 vote150 views1 answer
Sql query row number group by
SQL
1 vote126 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote134 views1 answer
Sql check if column exists
SQL
0 vote156 views1 answer
Mysql where sum > 0
SQL
25 votes128 views6 answers
Sql update query
SQL
23 votes98 views3 answers
Mysqldump
SQL
4 votes122 views1 answer
Id primary key auto generated
SQL