Oracle›Date/Time Functions›TO_TIMESTAMP
←TO_DATE

TO_TIMESTAMPDate/Time Functions

TO_CHAR→

Converts a string to a TIMESTAMP.

Syntax

TO_TIMESTAMP(str, fmt)

Example

Enter values below to update the example in real time.

ts→
SELECT TO_TIMESTAMP('2024-06-27 14:30:00',
                        'YYYY-MM-DD HH24:MI:SS') AS ts FROM DUAL;