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

2 votes145 views2 answers
Calculate percentage in sql
SQL
1 vote126 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote131 views1 answer
Python mysql check if database exists
SQL
0 vote79 views1 answer
How to fetch highest score in minimum time using mysql
SQL
1 vote121 views1 answer
Order by oracle
SQL
-1 vote119 views1 answer
Window functions in sql
SQL
4 votes112 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
-1 vote107 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
3 votes110 views2 answers
Oracle sql truncate table
SQL
0 vote122 views1 answer
Including parameters in OPENQUERY
SQL