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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=us-ascii"> <META content="MSHTML 6.00.2900.2627" name=GENERATOR></HEAD> <BODY style="MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px"> <DIV>Quite new to MySQl and queries in general and would like some help in the following query:</DIV> <DIV>select prDate, prName, prLEmployee, prDescription, prTotalHours, prLStatus, prCompletionDate, prActive from tProject where prDate >=2005-05-09</DIV> <DIV> </DIV> <DIV>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.</DIV> <DIV> </DIV> <DIV>Thanks<BR></DIV></BODY></HTML>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]