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 vote363 views1 answer
Create table database in psql
SQL
6 votes353 views2 answers
Mysql get yesterday
SQL
10 votes370 views2 answers
Sql pagination offset
SQL
1 vote338 views1 answer
User privileges postgresql information_schema
SQL
0 vote350 views1 answer
Postgresql select fast check no rows
SQL
21 votes368 views4 answers
Add column mssql
SQL
0 vote363 views1 answer
Mysql change innodb to myisam
SQL
2 votes347 views1 answer
Sql alchemy or
SQL
-1 vote378 views1 answer
Utf8_encode mysql
SQL
0 vote380 views1 answer
Creating sqeuence in oracle database
SQL