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 vote110 views1 answer
What is a Database?
SQL
0 vote117 views1 answer
C# execute transact sql
SQL
0 vote144 views1 answer
Order by number of character in sql
SQL
0 vote111 views1 answer
Install sql server windows 10
SQL
10 votes115 views2 answers
What is database
SQL
1 vote98 views1 answer
Mysql select row with max value group by
SQL
4 votes108 views1 answer
Update table from another table oracle
SQL
0 vote93 views1 answer
Sqlite3 not commit
SQL
4 votes113 views2 answers
REST API
SQL
0 vote93 views1 answer
How to get employee having maximum experience in mysql
SQL