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 vote198 views1 answer
Ms Sql set us timezone
SQL
0 vote212 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote272 views1 answer
Regex mongoose
SQL
3 votes185 views1 answer
MySQL DELETE JOIN
SQL
1 vote198 views1 answer
Neo4j display all nodes and relationships
SQL
6 votes168 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote213 views1 answer
Oracle job schedules
SQL
0 vote252 views1 answer
Cahnge column name apex oracle
SQL
1 vote207 views2 answers
Laravel get sql query eloquent with parameters
SQL
1 vote206 views1 answer
Type int in mysql maxlenght
SQL