Oracle Error ORA-01880: the fractional seconds must be between 0 and 999999999

Oracle Error Message

ORA-01880: the fractional seconds must be between 0 and 999999999

Reason for the Error

The specified fractional seconds were not in the valid range.

Solution

Specify a value for fractional seconds between 0 and 999999999.