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

6 votes330 views3 answers
Mysql remove user privileges
SQL
0 vote292 views1 answer
Install ms sql server management studio
SQL
0 vote318 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote333 views1 answer
Sql max of two values
SQL
0 vote299 views1 answer
Run postgresql dump to csv
SQL
0 vote318 views1 answer
Radius search with point data in mysql
SQL
0 vote302 views1 answer
Dump multiple tables mysql
SQL
-1 vote277 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote293 views1 answer
Mysql auto increment default value with prefix month and year
SQL
18 votes287 views2 answers
Sql comments
SQL