[nflug] [off topic] Quick SQL Question

Tyler Poland tyler.poland at gmail.com
Tue Jun 19 17:24:20 EDT 2007


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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.nflug.org/pipermail/nflug/attachments/20070619/7906a6b2/attachment.html


More information about the nflug mailing list