OracleDate/Time FunctionsTO_DATE
EXTRACT

TO_DATEDate/Time Functions

TO_TIMESTAMP

Converts a string to a date.

Syntax

TO_DATE(str, fmt)

Example

SELECT TO_DATE('2024-06-27', 'YYYY-MM-DD') AS d FROM DUAL;