From: "Jon Miller" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Subject: Problem with query
Date: Tue, 24 May 2005 19:40:32 +0800
Quite new to MySQl and queries in general and would like some help in the
following query:
select prDate, prName, prLEmployee, prDescription, prTotalHours, prLStatus,
prCompletionDate, prActive from tProject where prDate >=2005-05-09
It generates a listing that has years from 2001 to present. All I'm
looking for is information start from 2005-05-09 to present.
Thanks
<< TEXT.htm >>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
Try putting quotes around the date
select prDate, prName, prLEmployee, prDescription, prTotalHours, prLStatus,
prCompletionDate, prActive from tProject where prDate >= '2005-05-09'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
