Group By With Timestamp

[luvrexx]

Hi,

I am writing a query that requires a date which is a timestamp,i am using the date()fun to eliminate the hrs:sec etc part. Moreover I also need to use group by here which is creating the problem.Its showing duplicate rows because i have to use the timestamp to group by.Can anyone help,please.

 

[unclerico]

so you are using the date as the parameter and then you are also grouping by that date?? the way i am interpreting it doesn't make sense...i guess i don't follow 100%

 

[henslecd]

You need to convert the date to a varchar, give it an alias, and group on the alias. Get rid of the timestamp field. You will NEVER be able to get what you want because of that field. You can't sum it, so you have to group by and group by with timestamp never works.