MySQL Forums
Forum List  »  Newbie

Select rows from date not time in where clause
Posted by: Tom Whitbread
Date: June 16, 2005 03:40AM

I have a problem, I am trying to select all the rows that where entered today and I have a datetime type column to store the date data in. How can I specify in my where clause to select where datecol=today and not have to specify the time? If I do where datecol=<?php date('Y-m-d'); ?> its not working

Options: ReplyQuote


Subject
Written By
Posted
Select rows from date not time in where clause
June 16, 2005 03:40AM


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.