{"id":562,"date":"2009-04-08T00:53:06","date_gmt":"2009-04-07T23:53:06","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=562"},"modified":"2019-06-05T12:06:45","modified_gmt":"2019-06-05T11:06:45","slug":"numero-de-semaine","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2009\/04\/08\/numero-de-semaine\/","title":{"rendered":"Num\u00e9ro de semaine calendaire MySQL"},"content":{"rendered":"

MySQL poss\u00e8de un grand nombre de fonctions pour g\u00e9rer les dates et le temps<\/a>. Il est possible de r\u00e9cup\u00e9rer le num\u00e9ro calendaire d’une semaine avec la fonction week<\/a>. Dimanche 5 avril nous \u00e9tions semaine 14. La fonction week nous le confirme:<\/p>\n

mysql> SELECT week('2009-04-05');\n+--------------------+\n| week('2009-04-05') |\n+--------------------+\n|                 14 |\n+--------------------+<\/pre>\n
Lundi 6 avril, nouvelle semaine, on passe donc \u00e0 la semaine 15:<\/p>\n
mysql> SELECT week('2009-04-06');\n+--------------------+\n| week('2009-04-06') |\n+--------------------+\n|                 14 |\n+--------------------+<\/pre>\n
Souci !!! Le r\u00e9sultat n’est pas celui esp\u00e9r\u00e9 (14 au lieu de 15). En fait la fonction week<\/em> prend un deuxi\u00e8me param\u00e8tre optionnel, qui permet de \u00ab\u00a0r\u00e9gler la pr\u00e9cision<\/em>\u00a0\u00bb (compter sur 53 ou 54 semaines, commencer la semaine un dimanche ou un lundi…) bref elle est compl\u00e8te et complexe…<\/p>\n
Le r\u00e9glage usuel est de mettre le deuxi\u00e8me param\u00e8tre \u00e0 3<\/strong><\/span> ! ou alors d’utiliser la fonction WEEKOFYEAR<\/span><\/strong><\/a>.<\/p>\n
mysql> SELECT weekofyear('2009-04-05');\n+--------------------------+\n| weekofyear('2009-04-05') |\n+--------------------------+\n|                       14 |\n+--------------------------+<\/pre>\n
mysql> SELECT weekofyear('2009-04-06');\n+--------------------------+\n| weekofyear('2009-04-06') |\n+--------------------------+\n|                       15 |\n+--------------------------+<\/pre>\n","protected":false},"excerpt":{"rendered":"
MySQL poss\u00e8de un grand nombre de fonctions pour g\u00e9rer les dates et le temps. Il est possible de r\u00e9cup\u00e9rer le num\u00e9ro calendaire d’une semaine avec la fonction week. Dimanche 5 avril nous \u00e9tions semaine 14. La fonction week nous le confirme:<\/p>\n
mysql> SELECT week(‘2009-04-05’);<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[88,8],"tags":[248,119,117,118],"class_list":["post-562","post","type-post","status-publish","format-standard","hentry","category-astuce","category-mysql","tag-astuce","tag-semaine-calendaire","tag-week","tag-weekofday"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-94","jetpack-related-posts":[{"id":5502,"url":"https:\/\/dasini.net\/blog\/2022\/02\/16\/oracle-developer-week\/","url_meta":{"origin":562,"position":0},"title":"Oracle Developer Week","author":"Olivier DASINI","date":"16 f\u00e9vrier 2022","format":false,"excerpt":"L\u2019Oracle Developer Week est une semaine (du 21 au 25 f\u00e9vrier 2022) consacr\u00e9e au d\u00e9veloppement, rien que pour toi, ami d\u00e9veloppeur ? Pas moins de 11 sessions en fran\u00e7ais et des ateliers sur les th\u00e8mes suivants...","rel":"","context":"Dans "Cloud"","block_context":{"text":"Cloud","link":"https:\/\/dasini.net\/blog\/category\/cloud\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/02\/MySQL_Kubernetes_Cloud-native_600x314_SPEAKER_OD_MG.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/02\/MySQL_Kubernetes_Cloud-native_600x314_SPEAKER_OD_MG.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/02\/MySQL_Kubernetes_Cloud-native_600x314_SPEAKER_OD_MG.jpg?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":758,"url":"https:\/\/dasini.net\/blog\/2009\/09\/16\/utiliser-xml-avec-mysql-5-1-part-45\/","url_meta":{"origin":562,"position":1},"title":"Utiliser XML avec MySQL 5.1 (part 4\/5)","author":"Olivier DASINI","date":"16 septembre 2009","format":false,"excerpt":"Les fonctionnalit\u00e9s XPath de MySQL 5 MySQL 5 offre la possibilit\u00e9 de pouvoir ex\u00e9cuter des requ\u00eates XPath sur un flux XML, gr\u00e2ce \u00e0 la fonction extractValue(). Le r\u00e9sultat r\u00e9cup\u00e9r\u00e9 est la concat\u00e9nation de la valeur textuelle de chacun des n\u0153uds trouv\u00e9s (chaque valeur \u00e9tant dissoci\u00e9e des autres par un espace\u2026","rel":"","context":"Dans "MySQL"","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":738,"url":"https:\/\/dasini.net\/blog\/2009\/08\/26\/oracle-sun-cest-valide-cote-americain\/","url_meta":{"origin":562,"position":2},"title":"Oracle-Sun : c’est valid\u00e9… c\u00f4t\u00e9 am\u00e9ricain","author":"Olivier DASINI","date":"26 ao\u00fbt 2009","format":false,"excerpt":"Si la justice am\u00e9ricaine a donn\u00e9 son feu vert \u00e0 l'acquisition de Sun Microsystems par Oracle, les deux entreprises attendent encore celui de la Commission europ\u00e9enne. Le suspens a pris fin (si tant est qu'il y en eut un). La Justice am\u00e9ricaine (le DoJ) a valid\u00e9 l'acquisition de Sun Microsystems\u2026","rel":"","context":"Dans "Divers"","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":533,"url":"https:\/\/dasini.net\/blog\/2009\/03\/26\/apero-lemugfr-lors-de-solution-linux-2009\/","url_meta":{"origin":562,"position":3},"title":"Ap\u00e9ro LeMUG.fr lors de Solution Linux 2009","author":"Olivier DASINI","date":"26 mars 2009","format":false,"excerpt":"Le Mug.fr sera pr\u00e9sent sur le village associatif pendant Solution Linux (31 Mars, 1er et 2 Avril 2009 - Porte de Versailles) venez nous rendre visite. Mercredi 1er Avril, pendant la \u2018nocturne\u2019 nous vous invitions \u00e0 venir f\u00eater le Mug sur le stand F30 pr\u00eat\u00e9 pour l\u2019occasion par Anaska du\u2026","rel":"","context":"Dans "Conf\u00e9rence"","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":505,"url":"https:\/\/dasini.net\/blog\/2009\/03\/09\/toolkit-dev-nouvelle-rubrique-sur-dasininet\/","url_meta":{"origin":562,"position":4},"title":"Toolkit DEV: nouvelle rubrique sur dasini.net","author":"Olivier DASINI","date":"9 mars 2009","format":false,"excerpt":"Nouvelle rubrique sur dasini.net: Toolkit DEV Le but de cette rubrique est de synth\u00e9tiser les commandes les plus utiles aux d\u00e9veloppeurs MySQL. Vous retrouverai donc une liste, non exhaustive, des commandes sql les plus utilis\u00e9es lors du d\u00e9veloppement d'une application, ainsi qu'un exemple d'utilisation.","rel":"","context":"Dans "Non class\u00e9"","block_context":{"text":"Non class\u00e9","link":"https:\/\/dasini.net\/blog\/category\/non-classe\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":779,"url":"https:\/\/dasini.net\/blog\/2009\/10\/01\/utiliser-xml-avec-mysql-5-1-part-55\/","url_meta":{"origin":562,"position":5},"title":"Utiliser XML avec MySQL 5.1 (part 5\/5)","author":"Olivier DASINI","date":"1 octobre 2009","format":false,"excerpt":"Voil\u00e0 un petit panorama de l'utilisation des fonctionnalit\u00e9s XML de MySQL. Comme nous l'avons vu, g\u00e9n\u00e9rer le r\u00e9sultat d'une requ\u00eate au format XML reste tr\u00e8s simple avec le client texte mysql, idem pour la g\u00e9n\u00e9ration d'une sauvegarde (mysqldump). De plus, bien que n'\u00e9tant pas un base de donn\u00e9es XML, ont\u2026","rel":"","context":"Dans "MySQL"","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/comments?post=562"}],"version-history":[{"count":12,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/562\/revisions"}],"predecessor-version":[{"id":3155,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/562\/revisions\/3155"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}