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 vote104 views1 answer
Mysql xampp reset root password
SQL
0 vote106 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
32 votes100 views6 answers
Insert select
SQL
-1 vote110 views8 answers
Sql to c# linq converter online
SQL
0 vote152 views1 answer
Python mysql check if database exists
SQL
3 votes100 views3 answers
C# sql select
SQL
-1 vote94 views1 answer
Round up and down sql
SQL
16 votes122 views3 answers
Get count of duplicate records
SQL
0 vote121 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote98 views1 answer
Sqlite update only if greater
SQL