PostgreSQL – CURRENT_DATE Function
The PostgreSQL CURRENT_DATE function returns the current date.
Syntax: CURRENT_DATE
Return value:
The CURRENT_DATE function returns a DATE value that represents the current date.
Example 1:
The following statement shows how to use the CURRENT_DATE function to get the current date:
SELECT CURRENT_DATE;
Output:
Example 2:
The CURRENT_DATE function can be used as a default value of a column. So create a table named delivery for demonstration:
CREATE TABLE delivery( delivery_id serial PRIMARY KEY, product varchar(255) NOT NULL, delivery_date DATE DEFAULT CURRENT_DATE );
In the delivery table, there is the delivery_date whose default value is the result of the CURRENT_DATE function. Let’s add some data to it.
INSERT INTO delivery(product) VALUES('Data Structure And Algorithm Edition 1');
Third, verify whether the row was inserted successfully with the current date by using the following:
SELECT * FROM delivery;
Output: