CREATE TABLE DIMDATE (
DATEKEY INT PRIMARY KEY,
FULLDATE TIMESTAMP(2) NOT NULL,
DAYOFMONTH INT NULL,
DAYSHORTNAME VARCHAR(4) NULL,
DAYNAME VARCHAR(9) NULL,
WEEKOFMONTH INT NULL,
WEEKOFQUARTER INT NULL,
MONTHNAME VARCHAR(9) NULL,
QUARTER CHAR(1) NULL,
FULLYEAR CHAR(4) NULL,
MMYYYY CHAR(6) NULL,
FIRSTDAYOFMONTH DATE NULL,
LASTDAYOFMONTH DATE NULL,
FIRSTDAYOFQUARTER DATE NULL,
LASTDAYOFQUARTER DATE NULL,
FIRSTDAYOFYEAR DATE NULL,
LASTDAYOFYEAR DATE NULL,
ISWEEKDAY CHAR(1) NOT NULL,
ISHOLIDAY CHAR(1) NOT NULL
);
/* Setting the format for timestamp and date */
ALTER SESSION SET NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH:MI:SS';
ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD';
INSERT INTO DIMDATE VALUES (
301,
TO_TIMESTAMP('2024-03-01 00:00:00'),
1,
'Fri',
'Friday',
1,
9,
'March',
'1',
'2024',
'032024',
TO_DATE('2024-03-01'),
TO_DATE('2024-03-31'),
TO_DATE('2024-01-01'),
TO_DATE('2024-03-31'),
TO_DATE('2024-01-01'),
TO_DATE('2024-12-31'),
'Y',
'N'
);
I’m trying to insert the values but I could not identify the error. The specific error message for this one is ORA-01843: An invalid month was specified. Error at Line: 8 Column: 0. However, this snippet started at line 413. Where did I went wrong?
I did not try anything yet since I’m not familiar with Oracle SQL, however I expect that I could insert values them without errors
New contributor
Bryan Reamillo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.