can not retrive info from table

[sakib_rijwan]

Im trying to retrieve information from a table; I give a date in the form of "yyyy-mm-dd" but in the table date is stored in date/timestamp formate. So while im comparing my inputted date with the table date, no match is found. is there any way to select only the date part of the table field?
please help me

[arunss]

You can try like this...
SELECT * FROM TABLE_NAME WHERE date(`CreatedDate` ) > date('2009-12-10')

or

SELECT *
FROM TABLE_NAME
WHERE date( `CreatedDate` )
BETWEEN date( '2009-12-9' )
AND date( '2009-12-11' )

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

[moerpheus]

i think this will help. click here!