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

1 vote328 views1 answer
Sql padd let with zeros
SQL
0 vote328 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote313 views1 answer
Concat column value of same user in mysql
SQL
3 votes313 views5 answers
Mysql get last inserted id
SQL
1 vote358 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote337 views1 answer
Enable sql server full text indexing
SQL
0 vote306 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
1 vote309 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote344 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
2 votes367 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL