How can I work out what curdate() in MySQL is returning?

Question

I'd like to know when I write a query like

SELECT id FROM users WHERE expiry > curdate()

How can I work out what the curdate() is returning? I just switched servers of a site and it appears to be throwing it out, by perhaps returning a different curdate().

Thanks

Answer 1

SELECT CURDATE();

Answer 2

From the documentation, CURDATE():

Returns the current date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in a string or numeric context.