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 vote216 views1 answer
Search db for table name
SQL
1 vote223 views1 answer
Error code 1055
SQL
1 vote239 views1 answer
Epoch time converter in snowflake
SQL
0 vote218 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote239 views1 answer
Create table database in psql
SQL
5 votes215 views2 answers
Update all rows mysql
SQL
0 vote238 views1 answer
Oracle concat datetime
SQL
0 vote249 views1 answer
Date datatype in livesql
SQL
2 votes212 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
3 votes213 views2 answers
Having in mysql
SQL