Unable to insert current_timestamp in MySQL using c# Stored Procedure

Question

Sample code snippet:

command.Parameters.Add(new MySqlParameter("@Created_Date", MySqlDbType.Datetime)).Value = DateTime.Now;

Declaration in Stored Procedure "Created_Date DATETIME"

error code: Input string was not in a correct format.

Answer 1

Try this:

command.Parameters.Add(new MySqlParameter("@Created_Date", MySqlDbType.Timestamp)).Value = DateTime.Now;