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

2 votes143 views1 answer
Mysql id of inserted row
SQL
1 vote141 views2 answers
Postgresql check privileges on schema
SQL
49 votes220 views6 answers
Install mysql ubuntu
SQL
0 vote130 views1 answer
Drop specific row postgresql
SQL
0 vote127 views1 answer
Mysql case when null
SQL
0 vote242 views1 answer
Multiple replace value mssql
SQL
5 votes125 views3 answers
Sql max value in column
SQL
0 vote119 views1 answer
QCompleter con sql
SQL
0 vote140 views1 answer
Search In the Data using ObjectName
SQL
2 votes141 views1 answer
Mariadb select multiple rows into one column
SQL