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.

Steve

At 12:12 PM 5/14/2003 -0500, Darryl Hoar wrote:
>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
>
>--
>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.


Thread
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