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 vote225 views1 answer
Convert sql server guid to varbinary
SQL
0 vote246 views1 answer
Typeorm raw sql
SQL
1 vote238 views2 answers
Mysql insert generate serie
SQL
22 votes262 views4 answers
Date format mysql
SQL
2 votes248 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote216 views1 answer
Sql requete number pair
SQL
0 vote224 views1 answer
Install package for sqlserver in asp.net core
SQL
4 votes251 views1 answer
W3schools create table
SQL
0 vote223 views1 answer
Show function mysql
SQL
27 votes237 views4 answers
Get all tables with column name sql
SQL