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 vote225 views2 answers
Create-toys-table-with-toy_name-column
SQL
-1 vote190 views3 answers
Create temp table in sql
SQL
0 vote193 views1 answer
Drop column from local database postgres pgadmin
SQL
11 votes248 views3 answers
Pl sql example
SQL
4 votes149 views2 answers
Create table if not exists postgres
SQL
0 vote205 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote186 views1 answer
Oracle dynamic select into
SQL
16 votes198 views4 answers
Mysql import from sql file
SQL
0 vote201 views1 answer
How to change mysql root password in windows 10
SQL
0 vote248 views1 answer
Truncate a table then insert data
SQL