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 vote193 views1 answer
Sql requete number pair
SQL
0 vote205 views1 answer
Like and not like together in sql
SQL
0 vote139 views1 answer
Import csv to mysql
SQL
0 vote192 views1 answer
How to add unique key constraint in mysql
SQL
3 votes174 views3 answers
C# sql select
SQL
0 vote172 views1 answer
Select only one row sql
SQL
0 vote194 views1 answer
Mysql conf.d exampel
SQL
1 vote192 views1 answer
Sql group by sum with condition
SQL
0 vote198 views1 answer
Excel vba import data to sql server
SQL
0 vote185 views1 answer
Get id if is not equal in certain table
SQL