How to fix the Oracle error ORA-14120: incompletely specified partition bound for a DATE column?

In this post, you’ll learn more about the Oracle ErrorORA-14120: incompletely specified partition bound for a DATE column with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-14120: incompletely specified partition bound for a DATE column

Reason for the Error ORA-14120: incompletely specified partition bound for a DATE column

An attempt was made to use a date expression whose format does not fully (i.e. day, month, and year (including century)) specify a date as a partition bound for a DATE column. The format may have been specified explicitly (using TO_DATE() function) or implicitly (NLS_DATE_FORMAT).

How to fix the Error ORA-14120: incompletely specified partition bound for a DATE column ?

You can fix this error in Oracle by following the below steps

Ensure that date format used in a partition bound for a DATE column supports complete specification of a date (i.e. day, month, and year (including century)). If NLS_DATE_FORMAT does not support complete (i.e. including the century) specification of the year, use TO_DATE() (e.g. TO_DATE(’01-01-1999′, ‘MM-DD-YYYY’) to fully express the desired date.