Getdate function in postgresql

Postgresql get date from datetime

SELECT DATE(column_name) FROM table_name;

Source: tableplus.com

Postgre query date

SELECT * FROM data WHERE date = '2020-12-21'

Getdate function in postgresql

SELECT NOW();
              now
-------------------------------
 2017-03-18 08:21:36.175627+07
(1 row) 
Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Similar codes

1 vote353 views1 answer
Sample clause in sql
SQL
0 vote368 views1 answer
Tsql delete all rows
SQL
0 vote405 views1 answer
Oracle show grants on table
SQL
2 votes353 views1 answer
Drop table purge
SQL
11 votes387 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
2 votes394 views2 answers
Postgres change owner of schema
SQL
1 vote313 views1 answer
Insert into sql
SQL
0 vote408 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote357 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote1.2K views1 answer
Mysql custom sort order
SQL