cfquery date help

mSQL has a whole array of built-in date functions you can use:

SELECT ..., your_date_column
FROM members
WHERE YEAR(your_date_column) = YEAR(NOW()) AND MONTH(your_date_column) =
MONTH(NOW())

note that all the functions above are MySQL functions, NOT cf functions,
so DO NOT use # around them.


Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

Your date field might appear like yyyy-mm-dd, but that's a display thing. I don't use mysql but when I googled "mysql date functions" I found this. http://www.w3schools.com/SQL/sql_dates.asp

Year and month functions did not appear, but curdate returns the current date. That being the case, Cold fusion functions are probably a better way to go.

Use a combination of now(), year, month, and dateadd to get the 1st day of the current month and the first day of the next month. Let's call those variables date1 and date2.

They get used in your query like this

where renewal_date >= <cfqueryparam value="#date1#">
and renewal_date < <cfqueryparam value="#date2#">

If your db has functions named year and month, and most do, that would be a good start. Equally valuable, and likely available would be a db function that returns the current date.