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 vote269 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
2 votes264 views1 answer
Sql as
SQL
0 vote259 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote254 views1 answer
Gcloud check sql
SQL
0 vote240 views1 answer
Selects all the columns from the sailors table
SQL
0 vote260 views1 answer
How to use select union and loop
SQL
17 votes261 views6 answers
Current date in sql
SQL
-1 vote243 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote262 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote250 views1 answer
Sql server select top 2 of each group
SQL