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 vote171 views1 answer
Is sql fast
SQL
0 vote184 views1 answer
Store case result sql
SQL
0 vote148 views1 answer
Foreign key multiple columns
SQL
0 vote198 views1 answer
How to get number of months between 2 dates sql server
SQL
-1 vote134 views3 answers
Create temp table in sql
SQL
7 votes144 views1 answer
Xampp reset mysql
SQL
14 votes145 views4 answers
Import database through command line
SQL
2 votes142 views2 answers
Mysql count rows returned
SQL
0 vote138 views1 answer
Oracle call a function in a insert statement
SQL
19 votes135 views4 answers
Rename database in sql
SQL