nuBuilder Forum

Posted: **Wed May 08, 2024 10:12 pm**

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.

Posted: **Wed May 08, 2024 10:26 pm**

Code: Select all

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

Posted: **Thu May 09, 2024 6:55 pm**

worked thanks

nuBuilder Forum

select where clause current date

select where clause current date

Re: select where clause current date

Re: select where clause current date