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 vote208 views1 answer
SQL check if record exist
SQL
4 votes179 views2 answers
Postgresql default value
SQL
16 votes195 views4 answers
Ascending order mysql
SQL
2 votes227 views2 answers
Mysql compare datetime to another datetime
SQL
9 votes177 views3 answers
Show table columns mysql command line
SQL
0 vote168 views1 answer
Output to file mysql
SQL
0 vote137 views1 answer
Calculate discount from original price sql
SQL
0 vote191 views1 answer
On delete set default
SQL
3 votes174 views1 answer
Show index table
SQL
0 vote200 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL