Inserting timestamp into Oracle database

Question

I'm trying to insert some timestamps into an Oracle DB table but getting an ORA-01843: not a valid month error. The format of the string is how the data is pulled so if there's any issue with that, I'll have to correct that after the data is pulled.

INSERT INTO SCHEMA.TABLE_NAME
(START_TIME,
 END_TIME
)
VALUES
(
 TO_TIMESTAMP('2016-12-19 13:30:00, YYYY-MM-DD HH24:MI:SS'),
 TO_TIMESTAMP('2016-12-19 14:33:00, YYYY-MM-DD HH24:MI:SS')
);

missing quotes around timestamp. these are 2 different arguments. use TO_TIMESTAMP('2016-12-19 13:30:00', 'YYYY-MM-DD HH24:MI:SS') — Vamsi Prabhala
– Vamsi Prabhala, Commented Dec 27, 2016 at 14:20
You are calling functions to convert strings to timestamps. You could simply use timestamp literals instead: VALUES ( timestamp '2016-12-19 13:30:00', timestamp '2016-12-19 14:33:00' );. — Thorsten Kettner
– Thorsten Kettner, Commented Dec 27, 2016 at 17:47

Gurwinder Singh · Accepted Answer · 2016-12-27 14:20:53Z

1

You missed to close the single quote after the date and start before the format mask:

INSERT INTO SCHEMA.TABLE_NAME
(START_TIME,
 END_TIME
)
VALUES
(
 TO_TIMESTAMP('2016-12-19 13:30:00', 'YYYY-MM-DD HH24:MI:SS'),
 TO_TIMESTAMP('2016-12-19 14:33:00', 'YYYY-MM-DD HH24:MI:SS')
);

answered Dec 27, 2016 at 14:20

Gurwinder Singh

39.7k6 gold badges62 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

WeVie Over a year ago

wow I've looked at this for 20 minutes or more. Thanks for pointing out my boneheadednesss. :)

Collectives™ on Stack Overflow

Inserting timestamp into Oracle database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related