CAST

 

FORMAT_DATE

For timestamps, Oracle omits fractional parts unless the format string “ff” is used. If “ff” does not specify a precision, Oracle returns the precision of the data type used to store the returned value.

PARSE_DATE

Does not push.

PARSE_TIMESTAMP

Format “ff” (fractional part) is valid only for TO_TIMESTAMP.

TO_CHAR

For timestamps, Oracle omits fractional parts unless the format string “ff” is used. If “ff” does not specify a precision, Oracle returns the precision of the data type used to store the returned value.

TO_DATE

Format “ff” (fractional part) does not work for this function.

TO_NUMBER

 

TO_TIMESTAMP

For timestamps, Oracle omits fractional parts unless the format string “ff” is used. If “ff” does not specify a precision, Oracle returns the precision of the data type used to store the returned value.