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

4 votes165 views1 answer
Check database name postgresql
SQL
0 vote161 views1 answer
Import big data to mysql
SQL
3 votes190 views5 answers
No module named 'MySQLdb'
SQL
0 vote156 views1 answer
How to search query in python3 sqlite3
SQL
3 votes181 views1 answer
Select database in sql
SQL
0 vote212 views1 answer
Oracle sql date winter time
SQL
0 vote202 views1 answer
Change date in pivot table to month in sql server
SQL
2 votes163 views2 answers
Created at and updated at in mysql
SQL
1 vote166 views1 answer
What is in condition in sql
SQL
0 vote172 views1 answer
Sql find gaps in date ranges
SQL