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
sakib_rijwan
0
Newbie Poster
Recommended Answers
Jump to PostYou 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' )
All 2 Replies
arunss
0
Light Poster
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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.