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 vote145 views1 answer
Postpresql relation not found
SQL
5 votes236 views2 answers
Mysql date greater than 30 days
SQL
0 vote150 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote139 views1 answer
First mysql
SQL
0 vote148 views3 answers
Java hide mysql login credentials
SQL
0 vote139 views1 answer
Mysql table variables
SQL
0 vote180 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
7 votes159 views2 answers
Phpmyadmin change password
SQL
0 vote154 views1 answer
Get the First and Last Word from a String or Sentence
SQL
1 vote170 views1 answer
Psql connect
SQL