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

2 votes303 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
37 votes384 views6 answers
Mysql update
SQL
9 votes293 views2 answers
Mysql change value
SQL
14 votes345 views5 answers
Set password for postgres user ubuntu
SQL
1 vote305 views1 answer
Sql in array query
SQL
2 votes372 views2 answers
Python escape string for sql
SQL
3 votes285 views4 answers
Show columns from table
SQL
0 vote326 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote307 views1 answer
How to create a new db from dumb file mysql
SQL
4 votes316 views2 answers
Dbms output
SQL