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

4 votes337 views1 answer
Adding data to table in sql python
SQL
0 vote355 views1 answer
How to delete python anywhere mysql database
SQL
0 vote347 views1 answer
SQL loop with cursor
SQL
1 vote335 views1 answer
Count of tables in database mysql
SQL
0 vote339 views1 answer
Soql last week
SQL
0 vote355 views2 answers
How to type a blank discord messgae
SQL
-1 vote329 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote348 views1 answer
Mysql count number of occurrences in a column
SQL
3 votes367 views3 answers
Stop mysql ubuntu
SQL
0 vote364 views1 answer
Mysql 1 hour ago
SQL