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 vote226 views1 answer
Update and keep original value sql
SQL
1 vote241 views1 answer
Postgres see sequence current state
SQL
1 vote198 views1 answer
MySQL AND Operator
SQL
2 votes212 views1 answer
Codeigniter print last sql query
SQL
0 vote241 views1 answer
Mysql reset wp_options
SQL
0 vote169 views1 answer
Expose db in virtualbox
SQL
11 votes235 views3 answers
How to get last row of table in sql
SQL
4 votes214 views2 answers
Postgresql default value
SQL
0 vote221 views1 answer
SQL Server Enterprise
SQL
1 vote221 views1 answer
Sql server 2012 query history
SQL