Oracle database error code ORA-01811 – Julian date precludes use of day of year

Oracle Database Error Code ORA-1811 Description :
Julian date precludes use of day of year
Error Cause:
Both a Julian date and a day of the year were specified in the TO_DATE function. If a Julian date is specified, the day of the year (DDD) may not be specified, as it is contained in the Julian date.

How to Solve :
Remove the day of the year or the Julian date from the specification, then retry the operation.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»