EXTRACT
TO_DATE
TO_TIMESTAMP
Converts a string to a date.
TO_DATE(str, fmt)
SELECT TO_DATE('2024-06-27', 'YYYY-MM-DD') AS d FROM DUAL;