Member Avatar for karthik_ppts

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

  • 2 Contributors
  • 4 Replies
  • 147 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by karthik_ppts
Member Avatar for karthik_ppts

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

Member Avatar for divyakrishnan

Try this Query

SELECT date( date_time_field )
FROM DATA WHERE DATE( date_time_field) = DATE( NOW( ) )
Member Avatar for karthik_ppts

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 because: n/a
Member Avatar for karthik_ppts

this query solved my problem

SELECT * FROM `crm_callplan` WHERE substring( nextcall_datetime, 1, 10 ) = date( now( ) )
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.