[nflug] [off topic] Quick SQL Question
Franklin Kumro Jr
fkumro at gmail.com
Tue Jun 19 11:41:43 EDT 2007
No i dont have access to the machine right now, needed the information
to try in a bit.
On 6/19/07, joshj at linuxmail.org <joshj at linuxmail.org> wrote:
> 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
> nflug mailing list
> nflug at nflug.org
I do the voodoo that I do do with sudo!
More information about the nflug