Today's Date?

[The Hobo]

What's wrong with this SQL statement?:

SELECT * FROM vbsPosts WHERE createdBy='Dave' AND createdOn = CURDATE()

I want to select records that have field createdBy equal to Dave and field createdOn equal to today's date.

[The Hobo]

Almost have it working with this:

SELECT * FROM vbsPosts WHERE createdBy='Dave' AND DATE_FORMAT(createdOn, '%Y-%m-%d') = CURDATE()

[The Hobo]

Correction, it's working now with the above code.