2
Contributors
4
Replies
5
Views
6 Years
Discussion Span
Last Post by karthik_ppts
0

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.

Edited by karthik_ppts: n/a

0

this query solved my problem

SELECT * FROM `crm_callplan` WHERE substring( nextcall_datetime, 1, 10 ) = date( now( ) )
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.