Skip to Main Content

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!

Inserting date into a column - Not a valid month error

anishjpMay 4 2016 — edited May 4 2016

Hi guys

I created the following table.

CREATE TABLE proj_task_details (task_id NUMBER(10) PRIMARY KEY NOT NULL,

                                                    based_on number(10),

                                                    task_in_charge VARCHAR2(30),

                                                    task_start_date DATE,

                                                    task_end_date DATE

                                                    );

The default NLS DATE FORMAT is

PARAMETER                      VALUE                                 

------------------------------ ----------------------------------------

NLS_DATE_FORMAT                DD-MON-RR

I am trying to insert the below row.

INSERT INTO proj_task_details (task_id, based_on, task_in_charge, task_start_date, task_end_date)

values ('02', '01','KOCHAR', '13-SEP-07', '14-SEP-07');

It throws the below error.

INSERT INTO proj_task_details (task_id, based_on, task_in_charge, task_start_date, task_end_date)

values ('02', '01','KOCHAR', '13-SEP-07', '14-SEP-07')

Error report -

SQL Error: ORA-01843: not a valid month

01843. 00000 -  "not a valid month"

*Cause:   

*Action:


I do not understand why it cant take month in the "SEP" format?

This post has been answered by RogerT on May 4 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 1 2016
Added on May 4 2016
18 comments
24,723 views