I have a table which has 2 columns namely startdate and stucounts whose column types are datetime and the other column int.
If want to to get the total sum of stucounts coulumn for a particular day i was using the below mentioned query.It returned no results.
If there are many occurances of a particular day i want the total sum of the counts.
The startdate column has values in format of 2011-09-27 16:42:33.0
Here only date should be considered and time is not relevent
How do i get the total sum.
The below queries yielded no results
where startdate like '2011-09-27'