CURRENT_DATE SQL Function

Returns the server date and time each time it is called.

By contrast, TRANSACTION_DATE() retrieves the current server date only the first time it is called within a transaction. Subsequent calls to TRANSACTION_DATE() within the same transaction return the same date and time value. These subsequent calls are handled on the client and therefore give better performance than CURRENT_DATE().

Syntax

Notes

This is a convertible function resolved by USoft and thus supported on all RDBMS platforms.

See also

SQL Functions