mysql query to retrieve only records with a start_date > now()

I am trying to retrieve all records where the start_date is greater than the current timestamp. Any ideas why this might not be working:\[code\]WHERE (UNIX_TIMESTAMP(event_dates.start_date)) > DATE(NOW())\[/code\]and this is the example start_date column \[code\]2010-10-30\[/code\]
 
Back
Top