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 vote300 views1 answer
Make parameters nullable in sql server
SQL
1 vote298 views1 answer
Altrer name column postgres
SQL
0 vote281 views1 answer
Sql remove decimal places
SQL
1 vote273 views1 answer
Moodle query first user access
SQL
25 votes277 views5 answers
Uninstall mysql ubuntu
SQL
4 votes275 views1 answer
Sql quote in string
SQL
0 vote265 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote282 views4 answers
Stored procedure sql
SQL
0 vote290 views1 answer
List all indexes postgres
SQL
0 vote315 views1 answer
Eliminate zero from integer mysql
SQL