Get events by date

select distinct date(A.TSTAMP) as DATES, count(A.TSTAMP) as HITS from EVENTS A, EPIC_CHRONICLES B where A.EVENTID = B.EVENTID group by DATES;

Runs very slowly at customer.

Remove last character from sql field.

update set = left(, length()-1);