Re: Re: Datetime column index access

This is a multi-part message in MIME format. ------=____1074804270678_'dWzjik?+M Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit > > From: curtis@crowson1.com (Curtis Crowson) > Date: 2004/01/22 Thu AM 11:36:36 CST > To: informix-list@iiug.org > Subject: Re: Datetime column index access > > Re: 23:59:59 in a day. Possibly interesting aside. This only applies if you happen to be living on earth. Mars has a different day length. Now what is George going to do for a database when we fly him there? We've seen calendar issues before (I gather there are still cultures that use the toth (sp?) calendar, and others which have still not gone to the current gregorian calendar and are therefore currently 18 days off or so - not to mention the lunar calendars out there) but now you make me think that in the distant future we will have time issues as well. Something for future generations to think about. Although I'm sure some trekkie somewhere can tell us exactly what the current time and date are on the Klingon home world. cheers j. ------=____1074804270678_'dWzjik?+M Content-Transfer-Encoding: base64 Content-Type: null; name="replyAll" Content-Disposition: inline; filename="replyAll" 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. ------=____1074804270678_'dWzjik?+M-- sending to informix-list