Page 1 of 1

select with date only for datetime row

Posted: Sat Mar 22, 2008 7:25 pm
by jim_php
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 ?

Re: select with date only for datetime row

Posted: Sat Mar 22, 2008 8:56 pm
by Weirdan

Code: Select all

SELECT * FROM TABLE WHERE date(added)='2008-01-01'

Re: select with date only for datetime row

Posted: Sun Mar 23, 2008 5:21 am
by jim_php
gery thanks my friend ;)