The time periods can and will change so I was needing to group down to minute ( and even second ) if required.

Cheers folks!

Cheers folks for the responses.

I found another quite neat way to do it where I can specify the times down to seconds.

select * from transactions where tran_date between '03/01/2004' and '03/05/2004'...