INSERT INTO MANPOWER.VIPBADGE (
DOC_SRL, GRP_CD, DOC_TYPE, REC_TYPE, MV_MT, VESS_NAME, VESS_TYPE, IMO_NO, CALL_SIGN, REG_PORT,
AGENCY_FUN_CD, AGENCY_CD, EX_VESS_NAME, EX_CALL_SIGN, VESS_FLAG, SAT_ID, SATCOM_ID, FREE_BOARD, VESS_BLD_DT, VESS_BLD_PLACE,
DT_OF_DELI, PERMANENT_VALIDTY, SHIP_REG_CERT_NO, SHIP_REG_VALDT, SAFETY_MGMT_CERT_NO, SAFETY_MGMT_CERT_VALDT, VESS_HT, ISPS_COMPL, CAP2_CERT, BEAM,
LOA, LBP, MAX_DRAFT, PARL_BODY_LN, BOW_TO_MANIFOLD, GRT, NRT, DWT, SUMMER_DEAD_WT, TEU_CAP,
SBT, REDU_GRT, VESS_OWN, EMAIL_ID, CLASSFN_SOCIETY, HULL_INS_COMP_NAME, HULL_INS_COMP_VALDT, ENGN_TYPE, NO_OF_ENGN, ENGN_POWER,
PROPULSION_TYPE, NO_OF_PROPELLERS, NO_OF_BAYS, NO_OF_ROWS_ON_DECK, HATCH_COVER_TYPE, NO_OF_HATCH, MAX_MAN_SPEED, BOW_THRUSTER, BOW_THRUSTER_NO, BOW_THRUSTER_POWER,
STERN_THRUSTER_NO, STERN_THRUSTER_POWER, BULBOUS_BOW, MMSI_NO, PORT_APPR, APPR_BY, APPR_DT, ACTION_FLAG, ENTRY_BY, ENTRY_DT ) VALUES (
'8735910', 'VRD', 'VESPRO', 'N', 'MT', 'KDS TANKER 1', '153', '170224', '5778568', 'INMAA1', 'VA', '70009330', ' ', ' ', 'IN', ' ',
' ', '1', TO_DATE('01/01/2023','dd/MM/yyyy'), ' ', ' ', 'N', '6527849 ', TO_DATE('31/12/2025', 'dd/MM/yyyy'), '7539234578',
TO_DATE('28/12/2025', 'dd/MM/yyyy'), ' ', 'Y', 'N', '30.00', '120.00', '100.00', '10.00', ' 90.000', ' ', '1000.0', '
500.0', '1500.0', ' ', ' ', 'N', ' ', 'RAM ', ' ', ' ', ' ', '', 'DIESEL', '2', ' ', 'DIESEL', '2', ' ', ' ', ' ', '1', '14.0', 'Y', '2',
' ', '2', ' ', 'N', ' ', 'INKKK1', ' admin001',TO_DATE('17/02/2025', 'dd/MM/yyyy'), 'Y', ' ADMIN',SYSDATE )
I have provided all the dates in correct format but still getting error : ORA-01847: day of month must be between 1 and last day of month
Please explain me why ?