to_timestamp converts char of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to a value of TIMESTAMP datatype.
The optional fmt specifies the format of char. If you omit fmt, then char must be in the default format of the TIMESTAMP datatype. The optional 'nlsparam' has the same purpose in this function as in the to_char function for date conversion.