dcsimg
Results 1 to 2 of 2

Thread: Sql Help

  1. #1
    Join Date
    Jun 2007
    Posts
    2

    Question Sql Help

    I am getting an Ora-01847: day of month must between 1 and last day of month. Attatched image of table properties

    INSERT INTO TBLCASE (CASEID, OFFENSEDATE, CONVICTIONDATE, RELEASEDATE, REGISTRATIONDATE, PAIDREGESTRATION, ANNUALREGISTRATION, COMPLIANCE, NAMEID, VERIFICATIONDATE, OFFICERNAME)
    VALUES (51, TO_DATE('6/19/2007', 'MM/DD/YYYY'), TO_DATE('6/19/2007', 'MM/DD/YYYY'), TO_DATE('6/19/2007', 'MM/DD/YYYY'), TO_DATE('6/19/2007', 'MM/DD/YYYY'), 0, '0', NULL, '434494734', TO_DATE('6/19/2007', 'MM/DD/YYYY'), NULL)"
    Attached Images Attached Images

  2. #2
    Join Date
    Jun 2007
    Posts
    41

    Dba

    According to the attachment ANNUALREGISTRATION is type of DATE therefore '0' input is incorrect

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •