I have a table with a column named Shipped Date
. It is declared as a column of type DATE
and retains NULL marks by default.
When I "edited" other columns in the table it worked, but when I entered in a standard date value such as '9/14/2017' into the Shipped Date
column, the DBMS will let me enter it but it won't save it after I press TAB or ENTER.
I edited Shipped Date
directly in the table. I also tried to enter "2017-14-09" and "September 09, 2017" into the column, but it still won't save it.
I put in the date with a format of "07-APR-9"8, and then I click the Commit button, and an error message popped up that said:
Could not save file table ORDERS.
Tools/Preferences/Database/NLS/Date Format
has DD-MON-RR
.
Is RR supposed to be year? If I wanted it in month-Date-Year
then I suppose that it will be MON-DD-RR
. Is that correct? I did put it in the format of DD-MON-RR
(15-09-17) but it still does not work.
I am using Oracle SQL Developer version 17.2.0.188.
Best Answer
Community wiki answer:
There are loads of options/possibilities. See Datetime Format Models in the Database SQL Language Reference.
For example, if you have it set to
DD-MON-RR
, you should use15-SEP-17
.RR
lets you store 20th century dates in the 21st century using only two digits, as described in The RR Datetime Format Element: