select where clause current date

[databs1234]

Looking to show the records that are for today and in the future. Anyone know the correct syntax and function that would return today's date for a SQL statement? Something like the below:

SELECT * FROM view_eventplayer
WHERE eventdate >= currentdate()
ORDER BY last_name

currentdate() is one I've used with other databases. Appreciate the help.

[kev1n]

Code: Select all

SELECT * FROM view_eventplayer
WHERE eventdate >= CURDATE()
ORDER BY last_name

[databs1234]

worked thanks