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 vote348 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote352 views2 answers
How covert into int in maria db
SQL
0 vote339 views1 answer
Sql server count all tables rows
SQL
0 vote346 views1 answer
Sql server sleep
SQL
0 vote334 views1 answer
Mysqlimport
SQL
0 vote351 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
1 vote368 views1 answer
Update from select oracle
SQL
0 vote342 views1 answer
Mysql config slave
SQL
0 vote324 views1 answer
Renommer table sql
SQL
0 vote390 views1 answer
Sql server remove primary key without dropping table
SQL