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 vote136 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
1 vote122 views1 answer
Drop function
SQL
1 vote119 views1 answer
Isnull sql server
SQL
0 vote115 views4 answers
Mysql on kubernetes
SQL
5 votes129 views4 answers
SQL Order of execution
SQL
0 vote113 views2 answers
Sql update top 100
SQL
3 votes155 views2 answers
@sqlresultsetmapping
SQL
0 vote117 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
1 vote108 views1 answer
Floor function in sql oracle
SQL
0 vote123 views1 answer
Sql datediff month
SQL