{"id":8305,"date":"2019-08-04T13:41:05","date_gmt":"2019-08-04T11:41:05","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=8305"},"modified":"2019-08-04T13:55:38","modified_gmt":"2019-08-04T11:55:38","slug":"sql-obtenir-le-numero-du-jour-de-la-semaine-dune-date-avec-la-fonction-dayofweek","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=8305","title":{"rendered":"SQL : obtenir le num\u00e9ro du jour de la semaine d&#8217;une date avec la fonction DAYOFWEEK"},"content":{"rendered":"<p style=\"text-align: justify;\">La fonction SQL&nbsp;<em>DAYOFWEEK(date)<\/em> fournit le num\u00e9ro du jour de la semaine de la date indiqu\u00e9e en param\u00e8tre.<\/p>\n<p style=\"text-align: justify;\">Le num\u00e9ro renvoy\u00e9 par la fonction <em>DAYOFWEEK<\/em> s&#8217;interpr\u00e8te ainsi :<\/p>\n<p style=\"text-align: center;\">1 = dimanche, 2 = lundi&#8230;, 7 = samedi.<\/p>\n<p style=\"text-align: justify;\">Exemple :<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT DAYOFWEEK(EcritureValidDate) AS NumJourSem, EcritureNum\r\nFROM ECRITURES\r\nWHERE DAYOFWEEK(EcritureValidDate)=1 OR DAYOFWEEK(EcritureValidDate)=7;<\/pre>\n<p style=\"text-align: justify;\">Cet exemple fournit la liste des num\u00e9ros d&#8217;\u00e9critures comptables (<em>EcritureNum<\/em>) qui ont \u00e9t\u00e9 valid\u00e9es un samedi (7) ou un dimanche (1).<\/p>\n<p style=\"text-align: justify;\">Exemple pratique d&#8217;utilisation de la fonction <em>DAYOFWEEK<\/em> : <a href=\"https:\/\/www.auditsi.eu\/?p=256\">d\u00e9tection de la fraude ou des usurpations d\u2019identit\u00e9<\/a>.<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet : <a href=\"https:\/\/www.auditsi.eu\/?cat=1820\">Ma\u00eetriser le langage de requ\u00eate SQL<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"SQL%20%3A%20obtenir%20le%20num%C3%A9ro%20du%20jour%20de%20la%20semaine%20d%27une%20date%20avec%20la%20fonction%20DAYOFWEEK\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>La fonction SQL&nbsp;DAYOFWEEK(date) fournit le num\u00e9ro du jour de la semaine de la date indiqu\u00e9e en param\u00e8tre. Le num\u00e9ro renvoy\u00e9 par la fonction DAYOFWEEK s&#8217;interpr\u00e8te ainsi : 1 = dimanche, 2 = lundi&#8230;, 7 = samedi. Exemple : SELECT DAYOFWEEK(EcritureValidDate) AS NumJourSem, EcritureNum FROM ECRITURES WHERE DAYOFWEEK(EcritureValidDate)=1 OR DAYOFWEEK(EcritureValidDate)=7; Cet exemple fournit la liste des &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=8305\" class=\"more-link\">Continue reading &lsquo;SQL : obtenir le num\u00e9ro du jour de la semaine d&#8217;une date avec la fonction DAYOFWEEK&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"SQL%20%3A%20obtenir%20le%20num%C3%A9ro%20du%20jour%20de%20la%20semaine%20d%27une%20date%20avec%20la%20fonction%20DAYOFWEEK\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1820,282],"tags":[166,2059,1621,1643],"class_list":["post-8305","post","type-post","status-publish","format-standard","hentry","category-requetes-sql","category-sql","tag-analyse-de-donnees","tag-dayofweek","tag-fraude","tag-sql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8305","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8305"}],"version-history":[{"count":3,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8305\/revisions"}],"predecessor-version":[{"id":8309,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8305\/revisions\/8309"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}