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 vote278 views1 answer
Spark sql grows beyond 64 kb
SQL
3 votes263 views3 answers
Start postgresql ubuntu
SQL
0 vote251 views1 answer
Safe mysql
SQL
13 votes205 views2 answers
Oracle all source
SQL
1 vote253 views1 answer
Mysql count multiple columns in one query
SQL
0 vote278 views1 answer
How to select only a certain date sql
SQL
0 vote302 views1 answer
Generate a random otp in sql server
SQL
3 votes265 views1 answer
Null sql
SQL
1 vote257 views1 answer
Pagination sql
SQL
24 votes246 views4 answers
Mssql get all table names
SQL