List:General Discussion« Previous MessageNext Message »
From:Steve Buehler Date:May 14 2003 5:21pm
Subject:Re: Stupid select question
View as plain text  
do a
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
>doesn't work.
>Field1  is varchar(10)
>Field2 is date
>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 ?
>MySQL General Mailing List
>For list archives:
>To unsubscribe:
>This message has been scanned for viruses and
>dangerous content by the MailScanner at ow4, and is
>believed to be clean.

Stupid select questionDarryl Hoar14 May
  • Re: Stupid select questionRyan Fox14 May
  • Re: Stupid select questionSteve Buehler14 May
  • Re: Stupid select questionJames Moe14 May
  • RE: Stupid select questionDon Read14 May
  • Re: Stupid select questionAnthony R. J. Ball14 May
  • Re: Stupid select question(Terry Riley)14 May