sql SELECT eventID, venueID, name, DATE_FORMAT(dateTime, '%e') AS day, DATE_FORMAT(dateTime, '%m') AS month, DATE_FORMAT(dateTime, '%Y') AS year, IF(dateTime>NOW(), 1, 0) AS displayLink, isSoldOut FROM events WHERE DATE_FORMAT(dateTime, '%m-%e-%Y') = '03-30-2010' AND isPublished = 1