CAST

The maximum length for BINARY and VARBINARY is 4000. The maximum length for CHAR is 254. The maximum length of precision (p) and scale (s) is 31.

FORMAT_DATE

 

PARSE_TIMESTAMP

 

TO_CHAR

 

TO_DATE

 

TO_NUMBER

Empty-string input returns an exception.

TO_TIMESTAMP

Input of a string of eight white spaces returns a timestamp value. Shorter input string or a trimmed value throws an exception.