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

3 votes151 views1 answer
Postgresql db owner change
SQL
0 vote150 views1 answer
Kill a pid redshift
SQL
0 vote149 views1 answer
Google sheets filter rows above current cell
SQL
0 vote163 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote157 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote157 views1 answer
How to put is null in where in clause
SQL
1 vote185 views1 answer
Select not matching data with join table
SQL
0 vote148 views1 answer
Mysql match in serialized data
SQL
0 vote147 views1 answer
Copy Table from SQL to CSV
SQL
0 vote147 views1 answer
Mysql docker image for macbook m1
SQL