[nflug] [off topic] Quick SQL Question

[joshj at linuxmail.org]

It will work. Did you try it? You have half the statement already.


Thus spake Franklin Kumro Jr:

> 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
> _______________________________________________
> nflug mailing list
> nflug at nflug.org
> http://www.nflug.org/mailman/listinfo/nflug
>