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

9 votes164 views3 answers
Postgres make sql dump
SQL
6 votes139 views1 answer
SQL insert all columns
SQL
4 votes142 views3 answers
Is not null sql
SQL
0 vote124 views1 answer
If null don't update
SQL
0 vote125 views1 answer
Sql contains numeric characters
SQL
0 vote131 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote130 views1 answer
Postgres in operator with comma separated values
SQL
0 vote130 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote166 views1 answer
Select count postgres double row count > 1
SQL
2 votes137 views1 answer
Sql finding longest and shortest names in a fleld
SQL