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 vote300 views1 answer
What is top n result in sql
SQL
18 votes265 views4 answers
Foreign key mySql
SQL
1 vote300 views1 answer
Hackerrank sql test solutions
SQL
5 votes295 views2 answers
Mysql import gzip db
SQL
3 votes278 views1 answer
Postgres update column with value from another table
SQL
0 vote293 views2 answers
Alter table add multiple columns mysql
SQL
1 vote312 views3 answers
Postgresql get difference between two dates
SQL
2 votes273 views1 answer
How to select first row of database sql
SQL
0 vote307 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
2 votes277 views1 answer
Create table with primary key
SQL