current_date

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

Syntax

current_date()

Example 1 – Identifies the current date with datename:

1> select datename(month, current_date())
2> go

------------------------------ 
August

Example 2 – Identifies the current date with datepart:

1> select datepart(month, current_date())
2> go

----------- 
8 

(1 row affected)

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

ANSI SQL – Compliance level: Entry-level compliant.

Any user can execute current_date.