SELECT Field1 FROM Table1 WHERE Field2 = '2003-05-14';
Notice the forward ticks (apostrophies) around the date.
At 12:12 PM 5/14/2003 -0500, Darryl Hoar wrote:
>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
>Field1 is varchar(10)
>Field2 is date
>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 ?
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>This message has been scanned for viruses and
>dangerous content by the MailScanner at ow4, and is
>believed to be clean.