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

5 votes100 views5 answers
Sqlite install python
SQL
0 vote109 views1 answer
Asp.net core sql server stored procedure
SQL
0 vote99 views1 answer
Sql random decimal
SQL
14 votes153 views1 answer
How to export db from mysql
SQL
0 vote99 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote109 views1 answer
Drop-toys-table
SQL
1 vote103 views1 answer
Drop table if exists oracle
SQL
2 votes149 views3 answers
Mysql kill
SQL
0 vote102 views2 answers
Functions with parameters SQL
SQL
-1 vote142 views1 answer
Mysql faster insert
SQL