Paul, Friday, August 16, 2002, 1:19:15 AM, you wrote: PM> I have a column defined in a table as type date. I desire to include a date PM> comparison in the WHERE clause of the following statement. The following PM> statement is not working correctly, I suspect that there is a formatting PM> issue. The statement returns true even if USER.elig_date has an earlier date PM> then CURDATE().
PM> Here is my sql query: PM> select user_id from USER where USER.elig_date >= CURDATE() ; What is the version of MySQL server you use? What is the table structure? It's a very simple query and it should work. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php