How to:
The CURRENT_DATE function returns the current date of the operating system in the form YYYYMMDD.
CURRENT_DATE
This function returns the date in YYMD format.
On August 18, 2005, CURRENT_DATE will return 20050818.