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

0 vote314 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote367 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote345 views1 answer
Where date major today mysql
SQL
5 votes381 views1 answer
Mysql count lines
SQL
0 vote326 views1 answer
Big table in mysql
SQL
1 vote376 views1 answer
Mysql update inner
SQL
0 vote300 views1 answer
Mysql sleep connections
SQL
7 votes299 views1 answer
Mysql load data infile csv
SQL
0 vote398 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
3 votes348 views2 answers
To_char sql
SQL