my $tdt="select str_to_date(\'$dt\','%m/%d/%Y');";

my $in_rec="INSERT INTO $table (name,trans_date,price) VALUES(\'$name\',\'$tdt\',\'$prc\');";
my $sth=$dbh->prepare($in_rec);