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 vote294 views1 answer
Too many connections mysql
SQL
0 vote469 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote367 views1 answer
How to check common records in 2 table
SQL
10 votes316 views2 answers
Doublon sql
SQL
1 vote297 views2 answers
Sql server add time to date
SQL
7 votes316 views1 answer
Oracle pagination query rownum
SQL
2 votes285 views2 answers
How to DROP a table in mysql
SQL
0 vote303 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote246 views1 answer
Java spring boot connect to sql server
SQL
7 votes327 views2 answers
How to create index mysql
SQL