change datatype of 'date' in events table from date to datetime.