Oracle Solution for Error ora-01898

Solution for Oracle Error ORA-01898

ORA-01898: too many precision specifiers

What triggered the Error:

While trying to truncate or round dates, extra data was found in the date format picture

What should we do to fix it:

Check the syntax of the date format picture and retry.