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 vote153 views1 answer
Import in mysql without a software
SQL
1 vote163 views5 answers
Sql 2nd highest salary
SQL
0 vote197 views1 answer
Oracle string length
SQL
4 votes169 views4 answers
Date less than in sql
SQL
2 votes173 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
6 votes174 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote174 views1 answer
Cast float mysql
SQL
0 vote260 views1 answer
Mysql show schema
SQL
0 vote172 views1 answer
Mssql now diff 90 day
SQL
0 vote210 views1 answer
How to compile a function in oracle
SQL