in my database(MS SQL Server) my column datatype is datetime.
in my code when i do
Calendar fiveDays = Calendar.getInstance();
fiveDays.add(Calendar.DATE, -5); // get date for 5 days ago
String dtFiveDaysAgo= dateFormat.format(fiveDays.getTime())
String query = "Select enq.id as id," +
"enq.msg_text as msgText," +
"enq.email_addr as emailAddr," +
"enq.submit_user_id as submitUserId," +
"from threadings as enq where enq.last_modify_Date is null and enq.status=1 and "+
"enq.created_Date<='"+dtFiveDaysAgo+"'";
i receive the error:
syntax error in converting datetime from character string.
What is the correct way to do it?
thanks
|