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

3 votes312 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote321 views4 answers
Sql rownum
SQL
7 votes295 views6 answers
Reset identity column in sql server
SQL
0 vote326 views1 answer
Run sql script file and changes db name in this file using c#
SQL
7 votes307 views4 answers
What is my mysql version
SQL
0 vote310 views1 answer
Sql server information_schema temp tables
SQL
0 vote319 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote315 views1 answer
What is initial catalog in sql connection string
SQL
0 vote243 views1 answer
Check if due date is less than todays date sql
SQL
0 vote302 views1 answer
Update having mysql
SQL