Current Date Events

[bharanikumarphp]

am havig the table event, in that am having event_start, event_end,event_name

can u tell which query display the only current date events

can u tell the query,

i have tried with UNIX_TIMESTAMP() AND NOW() , THESE ARE NOT HELPED MY EXPECTED OUTPUT


ANY GREAT QUERY, PLZ SUGGEST

[legendx]

SELECT *
FROM table
WHERE CAST(event_start AS date) = CURRENT_DATE( )


There may be a better way.. but that's how I do it