[nflug] [off topic] Quick SQL Question

[Franklin Kumro Jr]

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


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