Try something along these lines: SELECT * FROM myTable WHERE myDate BETWEEN '5/7/2003 00:00:00' AND '5/7/2003 23:23:59'
It might work better. Brad >|> -----Original Message----- >|> From: Bosky, Dave [mailto:[EMAIL PROTECTED] >|> Sent: Thursday, June 19, 2003 2:45 PM >|> To: SQL >|> Subject: Get records that match a single date. >|> >|> >|> I'm having trouble returning records that match a specific date. >|> >|> I have a datetime(8) field called myDate with the following >|> data: 5/7/2003 >|> 8:00:00 AM >|> >|> Now if I try to query all records that match the date it >|> doesn't return any >|> matches. >|> SELECT * FROM myTable >|> WHERE myDate = '5/7/2003' >|> >|> I must be overlooking something really simple. >|> >|> Thanks, >|> Dave >|> >|> >|> >|> >|> HTC Disclaimer: The information contained in this message may >|> be privileged and confidential and protected from disclosure. >|> If the reader of this message is not the intended recipient, or >|> an employee or agent responsible for delivering this message to >|> the intended recipient, you are hereby notified that any >|> dissemination, distribution or copying of this communication is >|> strictly prohibited. If you have received this communication >|> in error, please notify us immediately by replying to the >|> message and deleting it from your computer. Thank you. >|> >|> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
