i have looked @ suggestions on other questions. have added tics, checked comparing date values, unable make code work. doing wrong in statement?
select * project project.completed_date >= '2015-01-01' order customer, projectname
it gives me exception
"javax.servlet.servletexception: java.sql.sqlexception: unknown column '2015-01-01' in 'where clause'"
why seeing date column , not value?
you should using single (or double) quotes around date, not backticks. hence query should like:
select * project project.completed_date >= '2015-01-01' order customer, projectname 
Comments
Post a Comment