FriendsNews header

search


Useful MySQL Queries

by hepya - 2020-12-07 17:53:31 ( in education, tech, computers, internet) [php version] rebuild

"Common MySQL Queries. Extending Chapter 9 of Get it Done with MySQL 5&Up

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

SET @yr 12, @wk=26, @day=0;
SELECT Str_To_Date( Concat(@yr,'-',@wk,'-',If(@day=7,0,@day) ), '%Y-%U-%w' ) AS Date;


Read, listen or watch the rest here: artful software


similar posts here ... and elsewhere

Comments (We enjoy free speech. Try not to offend, but feel free to be offended.)

Leave your own comment:

edit || rebuild || update || hide || set image

 

You might also like: dievna.com | hepya.com | holmesfamily.news | lazypugcafe.com | tarasfaves.com | williamarthurholmes.com | william's newsletter