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 vote275 views1 answer
Add multiple field in table sql
SQL
1 vote269 views1 answer
How to update date add hours in postgresql
SQL
3 votes245 views1 answer
Mysql UPDate with enner join
SQL
0 vote278 views1 answer
Running mysql from bash sc
SQL
0 vote259 views1 answer
Oracle search columns in schema
SQL
6 votes276 views2 answers
If not exists insert sql
SQL
10 votes252 views3 answers
Insert into auto increment mysql
SQL
0 vote260 views1 answer
How to print records of employees hired in particular month in oracle
SQL
2 votes281 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote271 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL