Finding "Next Monday" using MySQL Dates Tue, Dec 1. 2009
Several people who read my article on Exploring Mysql CURDATE and NOW. The same but different posed questions regarding how to return a valid MySQL date equivalent to "Next Monday" given any particular day, as determined by MySQL's CURDATE(). This is a little bit tricky, but can be done entirely in MySQL syntax, making it usable with Calendar applications built on top of MySQL queries, without the need to use serverside date functions. This builds upon concepts discussed in my prior article, so if you have trouble understanding the implications of using CURDATE or DATE_ADD, you should probably take a minute and read that article.
Continue reading "Finding "Next Monday" using MySQL Dates" »
Posted by David Rolston
in Web Tech Comments: (0)
Trackbacks: (0)
Defined tags for this entry: CURDATE, DateTime, DATE_ADD, DAYOFWEEK, MySQL, MySQL IF, Next Monday, Previous Monday
« previous page
(Page 1 of 1, totaling 1 entries)
next page »
