via artful software


Here’s an example: Compute date from year, week number and weekday

SET @yr=2012, @wk=26, @day=0;

SELECT Str_To_Date( Concat(@yr,’-‘,@wk,’-‘,If(@day=7,0,@day) ), ‘%Y-%U-%w’ ) AS Date;

Posted in Uncategorized
0 0 vote
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments