select with date only for datetime row
Posted: Sat Mar 22, 2008 7:25 pm
hello i have one table with one column called "added "and type "datetime"
for example in one sign the added row has the value "2008-01-25 12:30:20"
i want in mysql query load only by date like mysql_query(select * from signs where added = '2008-01-25'")or die();
but because the row has and the time stamp dont load these value ...
any idea to select well ?
for example in one sign the added row has the value "2008-01-25 12:30:20"
i want in mysql query load only by date like mysql_query(select * from signs where added = '2008-01-25'")or die();
but because the row has and the time stamp dont load these value ...
any idea to select well ?