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 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)

Get Practical PostgreSQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial