I want to display all data where the the expiry date is within next month or later, here is my code:
<cfquery name="ExpiryDate">
SELECT *
FROM Date
WHERE Expiry >=
</cfquery>
date formatMySQL
I want to display all data where the the expiry date is within next month or later, here is my code:
<cfquery name="ExpiryDate">
SELECT *
FROM Date
WHERE Expiry >=
</cfquery>
Best Answer
This is what you want:
MySQL date and time functions are documented here.