Jim R Posted March 29 Share Posted March 29 (edited) a.year = '25' How do I get year(curdate()) to produce just the final two years? I've searched and can't find a specific instance to match my question. left join `a_aau` `a` on(`p`.`id` = `a`.`playerID` and a.year = year(curdate()))) Edited March 29 by Jim R Quote Link to comment https://forums.phpfreaks.com/topic/327171-query-trying-to-compare-to-a-two-digit-year/ Share on other sites More sharing options...
mac_gyver Posted March 29 Share Posted March 29 in the mysql documentation, where the year() and curdate() functions can be found, there's a date_format() function that has a way of doing what you are asking - https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_date-format didn't everyone learn from the y2k problem not to store years as 2 digits? 1 Quote Link to comment https://forums.phpfreaks.com/topic/327171-query-trying-to-compare-to-a-two-digit-year/#findComment-1652363 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.