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 vote273 views1 answer
Pl sql search saurce code
SQL
0 vote266 views1 answer
What are the aggregate function in sql
SQL
0 vote312 views2 answers
How to prevent sql injection in java
SQL
0 vote328 views1 answer
New rails app with mysql
SQL
0 vote294 views1 answer
Sql delimiter to columns
SQL
15 votes302 views4 answers
Export mysql db using command line
SQL
2 votes269 views1 answer
Plsql left() function
SQL
0 vote305 views1 answer
Sql convert unix time to date
SQL
5 votes273 views1 answer
Oracle asynchronous procedure
SQL
5 votes285 views1 answer
How to use rank function in sql
SQL