Name
curdate , curtime , curdatetime — get current date and time
Synopsis
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.
Parameters
None.
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
Example24.57.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