• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

real quick!

Z

zimu

Diamond Member
I know this should be in the programming forum, but i need a response really fast!

in PHP/ MySQL, how do you build a query around a field in a database that is in date format (yyyy-mm-dd), but say only select this month?

like say select * from database where month = thismonth?
 
Dunno if mysql has it, but in sql server you could use the DATEDIFF function, where the date in DB is a difference of this month to a degree of 0, and you can plug in the parameters, like days, or in this case you'd want months as one. Do a search on that if mysql has it and nobody else answers 😀
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top