Returns the current date.
current_date()
Identifies the current date with datename:
1> select datename(month, current_date()) 2> go
------------------------------ August
Identifies the current date with datepart:
1> select datepart(month, current_date()) 2> go
----------- 8 (1 row affected)
Used to find the current date as it exists on the server.
ANSI SQL – Entry level Compliance.
Any user can execute current_date.
Datatypes Date and time datatypes
Commands select, where clause
