curdate
get current date and time
datetime curdate
();
datetime curdatetime
();
time curtime
();
Description
These functions return the current date or time as a date,
time or datetime, respectively. Internally they all return the
same value but data type reported to client differs.
Return Types
In a result set to client, the column types reported are as follows: TIME for curtime, DATE for curdate and DATETIME for curdatetime.
Errors
These functions do not signal errors.
Examples
Simple example
Get current date in different datatypes
SQL> select curdate(), curtime(), curdatetime();
callret callret callret
DATE TIME BINARY
_______________________________________________________________________________
2001.10.12 11:21.51 2001-10-12 11:21:51