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 vote68 views1 answer
Ms sql how to see active job current run time
SQL
2 votes118 views1 answer
Mysql sysdate
SQL
1 vote122 views1 answer
Postgresql transaction discard all
SQL
0 vote114 views1 answer
Sql row number in result set
SQL
1 vote122 views1 answer
Find size of all DB's postgres
SQL
2 votes117 views1 answer
No data found oracle
SQL
12 votes115 views4 answers
Mysql ifnull
SQL
0 vote109 views1 answer
Sql select rows between 1000 and 2000
SQL
1 vote81 views1 answer
Postgres division by zero
SQL
1 vote118 views2 answers
Replace text in sql
SQL