how to add a date when inserting data?

Hi!

I keep getting an error, missing comma on the insert statement. I am lost and do not understand what is wrong with the following code:

      my $sqll="insert into twroot.EE_SPARES_SHOP ( STATUS, SITE, CUSTOMER_CONTACT, CUSTOMER_E_MAIL,

                                                    TTC_REPRESENTITIVE,
SYSTEM_TYPE, SYSTEM_NAME, TEST_HEAD,
                                                    SYSTEM_SERIAL_NUMBER,
PART_NUMBER, PART_TYPE, PART_DESCRIPTION,
                                                    BOARD_SERIAL_NUMBER,
QTY, FAILURE, TUI_REV, CAL_DIAGS_REV,
                                                    DIAG_THAT_FAILED,
RESULTS_FILE, RMA_NUMBER, WEB, DATE_RECEIVED
                                                  )
                values( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, to_date( '$date_received', 'MM/DD/YY' )";
      $sth = $dbh->prepare( $sqll );
      die $dbh->errstr if $dbh->err;
      $rv = $sth->execute( $Status, $Site, $Customer_Contact,


$Customer_e_mail, $TTC_Representitive, $System_Type,

                           $System_Name, $test_head, $System_Serial_Number,


$Part_Number, $Part_Type, $Part_Description,

                           $Board_Serial_Number, $Qty,  $Failure, $TUI_Rev,


$Cal_Diags_Rev, $Diag_that_Failed,

                           $Results_File, $RMA_NUMBER, $YES
                         ) ||

Thanks for your help,

Jerry Received on Sun Mar 09 2003 - 03:35:42 CST