Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> date insert for oracle 7.3.4 onwards and ms sql server
Greetings.
I am trying to figure out a way to insert a date with a 4 letter year that is acceptable to Oracle 7.3.4 onwards as well as MS SQL Server. The below works on all except Oracle 7.3.4. Any suggestions?
Thanks
Jeff
INSERT INTO mm2user (id,pswd,name,dept,sec_lvl,mod_freq,exp_date) values ('LOGOUT','B8BBB3BBA1A0','17-Dec-2036');
Oracle 7.3.4 client results in sql*plus:
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input
string
Received on Wed Oct 10 2001 - 13:15:14 CDT
![]() |
![]() |