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 votes222 views1 answer
Rank function in oracle with example
SQL
0 vote234 views2 answers
Sql drop view if exists
SQL
1 vote224 views1 answer
Oracle sql create or replace view
SQL
0 vote256 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote232 views1 answer
Update using case in mysql
SQL
0 vote270 views1 answer
Modifier une valeur sql
SQL
0 vote238 views1 answer
How to export only procedures mysql
SQL
0 vote255 views1 answer
Learnxinyminutes sql
SQL
0 vote246 views2 answers
Import .sql into postgres db command
SQL
4 votes236 views4 answers
Date less than in sql
SQL