i want to get distinct dates in my table. in my database table the dates are stored with time(same date will come with different time). so i want to get the distinct date only
my database table date format mentioned below:
after getting the distinct dates , i will pass the dates and i want to get count value for each date.
if i get 10 distinct date value then i want to get 10 rows for date count.
how to get the distinct dates and also i want to get count for those dates.
i need to handle this in a stored procedure.
how to handle this.
need ur suggetsions with examples..