curated news for friends & family™ ... because friends don't let friends go uninformed! ™    

Useful MySQL Queries

by bill - 2020-12-03 ( education / tech / computers / internet )

"
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;"

Go to artful software

Comments (we believe in free speech, but not necessarily these comments)

Leave a new comment regarding "useful-mysql-queries":

post_ID = 1374