Modify percision for existing data


Is there a way to set precision on a specific database? Currently I have a database that has been working for about a month and queries that are greater then a few weeks are timing out which I suspect is due to number of entries which could be cleaned up if precision was in minutes or seconds.