error in mysql prepared statement timestamp?

Question

I'm using mysql to develop basic ddl statements but I created table with datatype of timestamp and getting an error as invalid statement for timestamp. And my code is :

ps.setTimestamp(4, m_datetime);

Thanks in advance.

Answer 1

ps.setTimestamp(4, m_datetime);

make sure that m_datetime has the proper timestamp format and its data type is java.sql.Timestamp