Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> date insert for oracle 7.3.4 onwards and ms sql server

date insert for oracle 7.3.4 onwards and ms sql server

From: Jeff Kish <jeff.kish_at_ait-mmii.com>
Date: Wed, 10 Oct 2001 14:15:14 -0400
Message-ID: <4s39st0eual1pgtl4158kadhasaiag96tq@4ax.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US