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

2 votes189 views1 answer
Mysql add boolean column
SQL
3 votes171 views1 answer
Pl sql check if variable is empty
SQL
3 votes188 views1 answer
Null sql
SQL
0 vote210 views1 answer
Mysql join only one column
SQL
0 vote192 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote216 views1 answer
Oracle chain step succeeded
SQL
0 vote192 views1 answer
SqlFunction does not exist
SQL
3 votes239 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
17 votes183 views6 answers
Mysql import sql file
SQL
8 votes195 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL