Re: Date Control Problem

MYSQL Leonard Tambunan <leonard@ins.itb.ac.id> wrote in message news:Pine.LNX.4.30.0101121217040.12384-100000@ins.itb.ac.id... > > What is the Database Engine? > > > Dear Sir / Madam, > > > > Case 1: > > My database, > > Table name -> Test. > > Field name -> due_date. > > > > Let say, > > due_date = 2001-01-01. > > > > Now, I would like to display all data from Test table where my due_date is > > before the current date. I tried the below SQL statement but it didn't work, > > SELECT * from Test where due_date >= curdate(); > > My display result should be zero. > > Any good solutions or suggestions for Case 1? > > > > > > Case 2: > > My database, > > Table name -> Test. > > Fields name -> posting_date, and expired_day. > > > > Let say, > > posting_date = 2000-12-20 > > expired_days = 14 days > > > > So my due date is 2001-01-02(from my own calculation). Same as case 1, I > > would like to display all data from Test table where expired_day plus > > posting_date is before the current date. > > My display result should be zero. > > Any good solutions or suggestions for Case 2? > > > > Thanks in advance. > > > > > > Best Regards, > > Ian. > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >