Insert statement with subsititutin variables and To_date

• lozar

  SSC Journeyman

  Points: 92

  More actions

  November 22, 2009 at 1:38 pm

  #214043

  I am trying to use a substitution variable with a to_date in a insert statement but I keep getting a "missing comma" error. I am not sure if this is written the correct way to accomplish this or if I am just missing something. The statement looks like this.

  INSERT INTO EMPLOYEE ( EMP_ID, START_DATE, END_DATE )

  VALUES ('&EMP_ID', TO_DATE( '&START_DATE','12 17 2009','MM DD YYYY'), TO_DATE('&END_DATE','12 17 2009','MM DD YYYY');

  I have also tried it this way

  INSERT INTO EMPLOYEE ( EMP_ID, START_DATE, END_DATE )

  VALUES ('&EMP_ID', '&START_DATE', TO_DATE('12 17 2009','MM DD YYYY'), '&END_DATE', TO_DATE('12 17 2009','MM DD YYYY');

  Your help is greatly appreciated.

• lozar

  SSC Journeyman

  Points: 92

  More actions

  November 24, 2009 at 9:29 am

  #1083537

  Ok sometimes you just need to go to sleep and wake up and the obvious will appear. Below is the proper way to write this.

  INSERT INTO EMPLOYEE ( EMP_ID, START_DATE, END_DATE )

  VALUES ('&EMP_ID', TO_DATE( '&START_DATE','MM DD YYYY'), TO_DATE('&END_DATE','MM DD YYYY'));