MySQL Forums
Forum List  »  MySQL Query Browser

Compare Date
Posted by: Tay Geok Lin
Date: June 02, 2009 11:09PM

Hi all

I want to ask how can i compare current date and the date i store in the database for my food?

eg. if i have a rice which expire in 4 days and a spaghetti that is going to expire in 2 days. I want it to display the one that expire in 2 days.

this is my query.
SELECT b.title FROM books b, avaliable a, ingredient i
where datediff(STR_TO_DATE(b.expiry, '%d-%b -%Y') , now()) Between 0 and 6
and b.book_id = a.book_id and a.Int_ID = i.Int_ID

Options: ReplyQuote

Written By
Compare Date
June 02, 2009 11:09PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.