java - Getting error in Select from MYSQL

Question

Getting error in Select from MYSQL on the line ResultSet rs = st.executeQuery(fetch_title);

Error msg : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':09:53' at line 1

String test = "27-May-2016 11:09:53";
String fetch_title = "SELECT title FROM competitor_analysis WHERE cron_date_time="+test+"";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(fetch_title);

Answer 1

Wrap up your date in speech marks in the query.

String fetch_title = "SELECT title FROM competitor_analysis WHERE cron_date_time='"+test+"'";