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

1 vote141 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote156 views1 answer
Postgresql print variable
SQL
0 vote132 views1 answer
Cast for print sql
SQL
2 votes187 views1 answer
Get the mysql table columns data type mysql
SQL
12 votes144 views2 answers
Delete all entries postgres
SQL
0 vote178 views1 answer
DATEDIFF minute postgres
SQL
6 votes153 views1 answer
Allsource oracle
SQL
1 vote130 views1 answer
Update mysql centos
SQL
0 vote145 views1 answer
How to update sql server version
SQL
57 votes325 views5 answers
How to create a new user in postgresql
SQL