CURRENT_DATE
CURRENT_DATE returns a timestamp value for the current date with the time set to 00:00:00.0:
Timestamp CURRENT_DATE()
Example
The following code:
SELECT CURRENT_DATE()
returns:
2004-10-27 00:00:00.0

Additional Links:

Copyright Actuate Corporation 2012