OracleDate/Time FunctionsCURRENT_DATE
SYSTIMESTAMP

CURRENT_DATEDate/Time Functions

CURRENT_TIMESTAMP

Returns the current date in the session time zone.

Syntax

CURRENT_DATE

Example

Enter values below to update the example in real time.

orders
order_date
SELECT * FROM orders
WHERE TRUNC(order_date) = CURRENT_DATE;