Between and miliseconds (timestamps)

Hi list,<br /><br />I noticed that when we use the keyword between in SQL statements we must considerer all the
milisecondswith 6 digits.<br /><br />I would like to know if we want to make a day selection we must use allways the
maxof possibilities like: <br /><br /><br />select * from base.table<br />where when<br />between <br />'2006-09-06
00:00:00.000000'<br />and<br />'2006-09-06 23:59:59.999999'<br />order by 2<br clear="all" /><br />Is there a simplest
wayor not ?<br /><br /> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- <br
/>                                  Atenciosamente(Sincerely)<br />                        Ezequias Rodrigues da
Rocha<br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é
melhordo que a melhor das ditaduras <br />The worst of democracies is still better than the better of dictatorships<br
/><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a>