SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01816: month may only be specified once

474734Dec 6 2005 — edited Dec 6 2005

Can anyone help a lowly undergrad with this please?

INSERT INTO calls (call_id, date_time, method, logged_by, sc_number, contact_id, hardware, os, software, version, description, initial_severity, current_severity, status)
VALUES (1,TO_CHAR(TO_DATE('05-DEC-2005 12:34:21','DD-MON-YYYY hh24:mm[:ss]')),'T','2','1','1','Unsure','Windows XP Pro','Publisher 2000','v3.216','Unable to access templates','4','4','1')
/

This gets error message: ORA-01816: month may only be specified once.

There is a thread for this error message but it seems to be populated with posts relating to ORA-01861
oops :D

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 3 2006

Added on Dec 6 2005

6 comments

7,450 views