how to check date from datetime field?

[Karthik_pranas]

Hi Frendz,
I have datetime field in database. now i want to filter out the record which are in today date using mysql query?

[Karthik_pranas]

Sorry my date field is not datetime datatype. Its varchar.

[divyakrishnan]

Try this Query

SELECT date( date_time_field )
FROM DATA WHERE DATE( date_time_field) = DATE( NOW( ) )

[Karthik_pranas]

Try this Query

SELECT date( date_time_field )
FROM DATA WHERE DATE( date_time_field) = DATE( NOW( ) )

Yes divyakrishnan, But this will work if the field is datetime datatype but mine is varchar.

[Karthik_pranas]

this query solved my problem

SELECT * FROM `crm_callplan` WHERE substring( nextcall_datetime, 1, 10 ) = date( now( ) )