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 vote143 views1 answer
Duplix print in Smartforms
SQL
2 votes133 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote119 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote123 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote139 views3 answers
Database restoring error
SQL
14 votes138 views3 answers
SQL trim
SQL
1 vote138 views1 answer
Sql select table header
SQL
0 vote137 views1 answer
How to select a row in sql
SQL
0 vote127 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote125 views1 answer
Insert data from stored procedure into table
SQL