Posted by: Tay Geok Lin
Date: June 02, 2009 11:09PM
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
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.