[nflug] [off topic] Quick SQL Question

[Franklin Kumro Jr]

Thanks guys!

On 6/19/07, Tyler Poland <tyler.poland at gmail.com> wrote:
> Yes... it will interpret the time provided as midnight or 00:00:00.
>
>
>
> On 6/19/07, Franklin Kumro Jr <fkumro at gmail.com> wrote:
> > 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
> > _______________________________________________
> > 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