Wednesday 28 June 2017

MySQL: week date range from week number in a query

Use STR_TO_DATE('201008 Monday', '%X%V %W'); to get a proper date like 2010-02-22 then use DATE_FORMAT to get the format you need.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.

Blog Archive