PHP/MySQL insert date inserts 0000-00-00

Hi folks I have the values from a .csv file being inserted into a mysql DB.

the csv looks like this:

04/29/2004,Ali,Islah,Alameda City,Quality Standards
04/29/2004,Dave,James,Alameda City,Quality Standards
04/29/2004,Lisa,Gibons,Alameda City,Quality Standards

The code looks like this:

[php]
       include("dbc.inc.php");
      
      $conn = @mysql_connect($host, $user, $pw, $dbname);
            @mysql_selectdb($dbname);

if (!$conn) {
        echo "Connection failed\n";
        exit;
            }
$filename = "/web/pages/scripts/" . $csv_file_name ;//. ".csv";
$fcontents = file($filename);
   while (list($line_num, $line) = each($fcontents))
    {
      {
      $msg = $line;

      $CSVRecord = explode (",", $msg);

      $StringLength = strlen($CSVRecord[4])-1;
        $CSVInsert="INSERT into certifications(seminar_date,last_name,first_name,agency,seminar)
                  Values('$CSVRecord[0]', trim('$CSVRecord[1]'), trim('$CSVRecord[2]'), trim('$CSVRecord[3]'), trim('$CSVRecord[4]'));";
                        
                        $result = mysql_query($CSVInsert) or die ("Error in query: $query. " . mysql_error());
                        
      if(!$CSVInsert) echo("Invalid Insert");
        
      }
  }

  mysql_close($conn);
[/php]

It's pretty straight forward and works except the date. When the seminar_date field is of type varchar it inserts fine. But when the seminar_date field is type datetime, as it should be, it inserts as 0000-00-00

I'm porting this app from postgresql to mysql. Any help would be greatly appreciated.Start Free Trial