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

57 votes290 views6 answers
Sql alter table
SQL
2 votes176 views1 answer
Enum in SQL Server
SQL
1 vote194 views2 answers
Foreign key set 0
SQL
4 votes152 views1 answer
Install postgres 12 on ubuntu
SQL
1 vote191 views2 answers
Oracle 18c xe ORA-65096
SQL
4 votes176 views2 answers
REST API
SQL
0 vote192 views2 answers
What is rownum in oracle
SQL
0 vote166 views1 answer
Postgresql import data from csv
SQL
1 vote200 views1 answer
Default
SQL
0 vote186 views1 answer
Except in sql
SQL