Re: Datetime column index access

curtis@crowson1.com (Curtis Crowson) wrote in message news:<eb5a5e2b.0401211538.3dddefcf@posting.google.com>... > Octavio G'mez <sogomez@hotmail.com> wrote in message news:<bumkj2$kaj$1@terabinaries.xmission.com>... > You could use between: > > select * from table1 where date_a between datetime(midnight of day) > datetime(11:59:59 pm of same day) While I am correcting everyone let me correct myself. This is just wrong. I can't believe that you answered this without testing it. I hope no one died because of this query. (You can be much tougher on yourself.) It should be 23:59:59 because there are apparently 24 hours in a day. Sorry, sorry, sorry.

On Thu, 22 Jan 2004 12:36:36 -0500, Curtis Crowson wrote: > curtis@crowson1.com (Curtis Crowson) wrote in message > news:<eb5a5e2b.0401211538.3dddefcf@posting.google.com>... >> Octavio G'''mez <sogomez@hotmail.com> wrote in message >> news:<bumkj2$kaj$1@terabinaries.xmission.com>... > >> You could use between: >> >> select * from table1 where date_a between datetime(midnight of day) >> datetime(11:59:59 pm of same day)> > While I am correcting everyone let me correct myself. > > This is just wrong. I can't believe that you answered this without testing > it. I hope no one died because of this query. (You can be much tougher on > yourself.) > > It should be 23:59:59 because there are apparently 24 hours in a day. > > Sorry, sorry, sorry. Ease off, you did say 11:59:59 PM! Art S. Kagel