Name
CURRENT_DATE -- Returns the current date.
Synopsis
CURRENT_DATE
Parameters
This function does not accept any parameters.
Results
- date
The current date. The returned data type is date.
Description
Use the CURRENT_DATE function to retrieve the current system date as an object of data type DATE. Use SET DATESTYLE to format the display of that date to your liking. See the Section called Data Types in Chapter 3" in Chapter 3, for more information on this variable and available options when setting it.
Examples
The following example retrieves the current date:
testdb=# SELECT CURRENT_DATE AS today;
today
------------
2001-10-29
(1 row)