Jim R Posted Saturday at 04:39 AM Share Posted Saturday at 04:39 AM (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 Saturday at 05:09 AM 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 Saturday at 06:18 AM Share Posted Saturday at 06:18 AM 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.