Yes... it will interpret the time provided as midnight or 00:00:00.<br><br>
<div><span class="gmail_quote">On 6/19/07, <b class="gmail_sendername">Franklin Kumro Jr</b> <<a href="mailto:fkumro@gmail.com">fkumro@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">No i dont have access to the machine right now, needed the information<br>to try in a bit.<br><br>On 6/19/07,
<a href="mailto:joshj@linuxmail.org">joshj@linuxmail.org</a> <<a href="mailto:joshj@linuxmail.org">joshj@linuxmail.org</a>> wrote:<br>> It will work. Did you try it? You have half the statement already.<br>><br>
><br>> Thus spake Franklin Kumro Jr:<br>><br>> > Can I perform a <= comparison on a datetime column (mysql) using only the<br>> > date?<br>> ><br>> > WHERE some_date <= '2003-05-05'
<br>> ><br>> > *some_date is a datetime<br>> ><br>> > Will this work as expected or will the additional time information (in<br>> > the db) invalidate the query?<br>> ><br>> > Thanks
<br>> > --<br>> > Frank<br>> > Shenanigans!!<br>> > I do the voodoo that I do do with sudo!<br>> > <a href="http://www.syncoder.com">http://www.syncoder.com</a><br>> > _______________________________________________
<br>> > nflug mailing list<br>> > <a href="mailto:nflug@nflug.org">nflug@nflug.org</a><br>> > <a href="http://www.nflug.org/mailman/listinfo/nflug">http://www.nflug.org/mailman/listinfo/nflug</a><br>> >
<br>> _______________________________________________<br>> nflug mailing list<br>> <a href="mailto:nflug@nflug.org">nflug@nflug.org</a><br>> <a href="http://www.nflug.org/mailman/listinfo/nflug">http://www.nflug.org/mailman/listinfo/nflug
</a><br>><br><br><br>--<br>Frank<br>Shenanigans!!<br>I do the voodoo that I do do with sudo!<br><a href="http://www.syncoder.com">http://www.syncoder.com</a><br>_______________________________________________<br>nflug mailing list
<br><a href="mailto:nflug@nflug.org">nflug@nflug.org</a><br><a href="http://www.nflug.org/mailman/listinfo/nflug">http://www.nflug.org/mailman/listinfo/nflug</a><br></blockquote></div><br>