Quick Ref.
Functions
date
number
string
Data Types
date
number
string
Compatibility
CURRENT_DATE
Engine OK Alternative
mysql yes
oracle yes
postgres yes
sqlserver no CONVERT(CHAR(10),CURRENT_TIMESTAMP,126)

CURRENT_DATE

CURRENT_DATE returns today's date. 

 CURRENT_DATE -> '2006-12-31'

Results
See also: