TO_DATE scalar function The TO_DATE function returns a timestamp that is based on the interpretation of the input string using the specified format. TO_DATE(string-expression ,format-string,6,precision-constant,locale-name,locale-name,6,precision-constant ) The schema is SYSIBM. The TO_DATE scalar function is a synonym for the TIMESTAMP_FORMAT scalar function.