current_date

Finds and returns the current date as it exists on the server.

Syntax

current_date()

Examples

Usage

See also select, where clause in Reference Manual: Commands.

Standards

ANSI SQL – Compliance level: Entry-level compliant.

Permissions

Any user can execute current_date.

Related concepts
Date and Time Datatypes
Related reference
dateadd
datename
datepart
getdate