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 vote137 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote157 views1 answer
Hour and minute between two datatime sql
SQL
0 vote148 views1 answer
Mysql query single row
SQL
0 vote222 views1 answer
Example database query
SQL
0 vote158 views1 answer
Get the next column of a table in mysql
SQL
0 vote162 views1 answer
Mysql get first 2 characters of string
SQL
0 vote180 views1 answer
Mysql remove last character
SQL
0 vote141 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote227 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
2 votes189 views1 answer
Select from array in psql
SQL