7 messages in com.mysql.lists.mysqlStupid select question
FromSent OnAttachments
Darryl Hoar14 May 2003 10:11 
Ryan Fox14 May 2003 10:20 
Steve Buehler14 May 2003 10:21 
James Moe14 May 2003 10:34 
Don Read14 May 2003 10:40 
Terry Riley14 May 2003 10:51 
Anthony R. J. Ball14 May 2003 10:58 
Subject:Stupid select question
From:Darryl Hoar (dar@osborne-ind.com)
Date:05/14/2003 10:11:39 AM
List:com.mysql.lists.mysql

Greetings, I have a table that has a column that is date type. I have data in the table, but no matter how I try to select specifing a where clause on the date, it doesn't work.

Table1 Field1 is varchar(10) Field2 is date

record Mary 2003-05-14

select field1 from Table1 where Field2=2003-05-14

returns the empty set.

if I try 05/14/03 it gives the same result.

How do I find the records with a specific date ?

thanks, Darryl