January 2002
Intermediate to advanced
640 pages
16h 39m
English
Content preview from Practical PostgreSQLBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Current_Date
Returns the current date.
Synopsis
CURRENT_DATE
Parameters
This function does not accept any parameters.
Results
dateThe 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 titled Data Types
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)