i just had this thought. i should take both dates, subtract them and multiply the figure by 24. then i should insert that many rows with their individual timestamps into the table in a sequential order. eg 2005-12-12 12:00:00 2005-12-13 01:00:00 and so on. can somebody please guide me in this. thanks.