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 vote354 views1 answer
Get parameter value in mysql trigger
SQL
0 vote346 views1 answer
Compression of dabatase mysqldumo
SQL
1 vote340 views1 answer
Sql group by error
SQL
-1 vote382 views1 answer
Pl sql drop trigger
SQL
0 vote357 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote352 views1 answer
How to connect postgresql database with java
SQL
2 votes339 views2 answers
Postgres set user as superuser
SQL
2 votes301 views1 answer
Sql view column data type
SQL
0 vote375 views1 answer
Add timestamp column to existing table t-sql
SQL
1 vote399 views1 answer
Oracle plan hash value
SQL