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

4 votes203 views1 answer
Is there any command to change postgres password
SQL
0 vote194 views1 answer
Power query case when
SQL
9 votes215 views6 answers
Check constraint in sql
SQL
0 vote200 views1 answer
Create a plsql object
SQL
1 vote213 views1 answer
Store select query result in variable sql server
SQL
9 votes200 views1 answer
Sql server get utc date
SQL
1 vote195 views1 answer
Increase date by one day in sql oracle
SQL
0 vote204 views1 answer
Order child below the parent in mysqli
SQL
2 votes191 views1 answer
Mysql time ago difference
SQL
3 votes198 views2 answers
Mysql create database
SQL