SQL.getTimestamp(): java.sql.SQLException.
java.sql.SQLException: Cannot convert value '08:38' from column 2 to TIMESTAMP.


     at com.mysql.jdbc.ResultSet.getTimestampFromString(ResultSet.java:5538)
     at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:5566)
     at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:5219)
     at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:5257)
     at de.bezier.data.sql.SQL.getTimestamp(Unknown Source)
     at argh.setup(argh.java:169)
     at processing.core.PApplet.handleDraw(PApplet.java:1383)
     at processing.core.PApplet.run(PApplet.java:1311)
     at java.lang.Thread.run(Thread.java:613)


etc..

i've tried deleting entries in the db and same errors.

i have a feeling it might be my php ...


//$email=$_POST['email'];
$date=date('jS M y');
$time=date('g:i a');

$date2=date('c');


$conn = mysql_connect('localhost','root','root') or die('Error connecting to mysql');
mysql_select_db('myDB');


$prayer=$_POST['prayer'];


//$prayer=mysql_real_escape_string($message);
//Take a new line after stringpos
$query="insert into prayers values ('".NULL."','".$message."','".$date2."')";


$result = mysql_query($query);

echo "<center>";
echo "Thanks";
echo '<br>';

echo "dfghskgd";
echo '<br>';
echo $date2;

echo " @ ";


echo "$time";


?>

Any ideas?

..sorry im such a pest.  i am a amateur trying to take on 3 languages in a very short space of time.

thank you thank you.