[nflug] [off topic] Quick SQL Question

Franklin Kumro Jr fkumro at gmail.com
Tue Jun 19 11:20:33 EDT 2007


Can I perform a <= comparison on a datetime column (mysql) using only the date?

WHERE some_date <= '2003-05-05'

*some_date is a datetime

Will this work as expected or will the additional time information (in
the db) invalidate the query?

Thanks
-- 
Frank
Shenanigans!!
I do the voodoo that I do do with sudo!
http://www.syncoder.com


More information about the nflug mailing list