{"id":198498,"date":"2023-08-02T07:30:00","date_gmt":"2023-08-02T07:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=198498"},"modified":"2023-11-09T13:44:05","modified_gmt":"2023-11-09T13:44:05","slug":"dateformat-sql-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/dateformat-sql-tout-savoir","title":{"rendered":"Dateformat SQL : Tout savoir de cette requ\u00eate"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"198498\" class=\"elementor elementor-198498\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-561e2f1 e-flex e-con-boxed e-con\" data-id=\"561e2f1\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b5bbbff elementor-widget elementor-widget-heading\" data-id=\"b5bbbff\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">En fonction des pays, des cultures ou des sources de donn\u00e9es, les dates peuvent \u00eatre \u00e9crites d\u2019une multitude de mani\u00e8res. Or, pour simplifier le traitement des donn\u00e9es, il est primordial de les uniformiser. Mais alors comment uniformiser ces dates ? Gr\u00e2ce au langage informatique SQL, il est possible d\u2019utiliser la requ\u00eate DATEFORMAT SQL. <\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-dd5b50e e-flex e-con-boxed e-con\" data-id=\"dd5b50e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7d069ee elementor-widget elementor-widget-heading\" data-id=\"7d069ee\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Pourquoi uniformiser les dates ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a3db1ff elementor-widget elementor-widget-heading\" data-id=\"a3db1ff\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">L\u2019uniformisation des donn\u00e9es pour mieux les exploiter<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3b40bdc elementor-widget elementor-widget-text-editor\" data-id=\"3b40bdc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">L\u2019uniformisation des dates s\u2019int\u00e8gre parfaitement dans l\u2019uniformisation des donn\u00e9es de votre database.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">En effet, les organisations disposent d\u2019un volume de donn\u00e9es de plus en plus cons\u00e9quent. Mais comme les sources et les formats sont extr\u00eamement vari\u00e9s, il est parfois <\/span><b>difficile de les exploiter<\/b><span style=\"font-weight: 400;\">. Alors pour apporter plus de valeur gr\u00e2ce aux donn\u00e9es, il est primordial de les harmoniser.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Afin de mener \u00e0 bien ce travail de standardisation, les organisations ont tout int\u00e9r\u00eat \u00e0 d\u00e9finir une strat\u00e9gie de <a href=\"https:\/\/datascientest.com\/comment-mettre-en-place-la-gouvernance-des-donnees-en-entreprise\">gouvernance des donn\u00e9es<\/a><\/span><span style=\"font-weight: 400;\">. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8a86922 elementor-widget elementor-widget-heading\" data-id=\"8a86922\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">L\u2019uniformisation des dates<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-314ea25 elementor-widget elementor-widget-text-editor\" data-id=\"314ea25\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Si l\u2019uniformisation des donn\u00e9es est d\u00e9terminante pour les entreprises, c\u2019est d\u2019autant plus important pour les dates. En effet, toutes les donn\u00e9es sont int\u00e9gr\u00e9es \u00e0 un jour et une heure pr\u00e9cise. Or, la connaissance de cette date peut avoir une <\/span><b>incidence sur la prise de d\u00e9cision<\/b><span style=\"font-weight: 400;\">. Il est donc primordial qu\u2019elles soient harmonis\u00e9es pour l\u2019ensemble de l&rsquo;organisation.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Mais dans la pratique, force est de constater que c\u2019est loin d\u2019\u00eatre toujours le cas.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">D\u2019une part, parce que les donn\u00e9es proviennent d\u2019une multitude de sources (r\u00e9seaux sociaux, site internet, rapport\u2026).\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">D\u2019autre part, parce que chaque pays dispose de son propre formatage. Par exemple, le 18 avril 2023 sera \u00e9crit de mani\u00e8re diff\u00e9rente selon les pays :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">en France : 18\/04\/2023<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">aux \u00c9tats-Unis : 04\/18\/2023<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">en Chine : 2023\/18\/04<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9caabba elementor-widget elementor-widget-text-editor\" data-id=\"9caabba\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Entre la diversit\u00e9 des sources de donn\u00e9es et des cultures<\/span><b>, le format des dates est tr\u00e8s souvent h\u00e9t\u00e9rog\u00e8ne.<\/b><span style=\"font-weight: 400;\"> C\u2019est pour cette raison que la requ\u00eate DATEFORMAT <a href=\"https:\/\/datascientest.com\/formation-sql\">SQL<\/a> <\/span><span style=\"font-weight: 400;\">est si utile. Son objectif est<\/span><span style=\"font-weight: 400;\">, en effet, de fournir \u00e0 l\u2019ensemble des utilisateurs de la base de donn\u00e9es un format de date facile \u00e0 lire et compr\u00e9hensible par tous. Mais alors comment \u00e7a fonctionne ?<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-478a1c8 elementor-widget elementor-widget-image\" data-id=\"478a1c8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/date_format1.png\" class=\"attachment-full size-full wp-image-198512\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/date_format1.png 800w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/date_format1-300x169.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/date_format1-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2189f5f elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"2189f5f\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Apprendre \u00e0 utiliser les requ\u00eates SQL<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c4df184 e-flex e-con-boxed e-con\" data-id=\"c4df184\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b3ab7a8 elementor-widget elementor-widget-heading\" data-id=\"b3ab7a8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment fonctionne la requ\u00eate DATEFORMAT-SQL ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4b9cbe2 elementor-widget elementor-widget-text-editor\" data-id=\"4b9cbe2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">La requ\u00eate DATE_FORMAT SQL permet de formater une date dans un format sp\u00e9cifique. C\u2019est la fonction \u00e0 privil\u00e9gier si vous souhaitez uniformiser les dates de l\u2019ensemble des donn\u00e9es.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Voici comment elle se pr\u00e9sente :\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><b>SELECT DATE_FORMAT(date,format)<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f19f4c5 elementor-widget elementor-widget-heading\" data-id=\"f19f4c5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Les formats<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a2587fc elementor-widget elementor-widget-text-editor\" data-id=\"a2587fc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Pour le format, vous avez la possibilit\u00e9 de choisir une cha\u00eene de caract\u00e8re parmi la liste ci-dessous :<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%a : nom du jour de la semaine abr\u00e9g\u00e9 (Sun, Mon, \u2026 Sat)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%b : nom du mois abr\u00e9g\u00e9 (Jan, Fev, \u2026 Dec)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%c : num\u00e9ro du mois (0, 1, 2, \u2026 12)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%D : num\u00e9ro du jour, avec le suffixe en anglais (0th, 1st, 2nd, 3rd, \u2026)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%d : num\u00e9ro du jour du mois, sous 2 d\u00e9cimales (00..31)\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%e : num\u00e9ro du jour du mois (0..31)\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%f : microsecondes (000000..999999)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%H : heure (00..23)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%h : heure (01..12)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%I : heure (01..12)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%i : minutes (00..59)\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%j : jour de l\u2019ann\u00e9e (001..366)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%k : heure (0..23)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%l : heure (1..12)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%M : nom du mois en anglais (January, February, &#8230;December)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%m : mois (00..12)\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%p : AM ou PM<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%r : heure au format 12-heures (hh:mm:ss suivi par AM ou PM)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%S : secondes (00..59)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%s : secondes (00..59)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%T : heure au format 24 heures (hh:mm:ss)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%U : Semaine (00..53), pour lequel le dimanche est le premier jour de la semaine; WEEK() mode 0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%u : Semaine (00..53), pour lequel le lundi est le premier jour de la semaine<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%V : Semaine (01..53), pour lequel le dimanche est le premier jour de la semaine (utilis\u00e9 avec %X)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%v : Semaine (01..53), pour lequel le lundi est le premier jour de la semaine; (utilis\u00e9 avec %x)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%W : nom du jour de la semaine en anglais (Sunday, Monday, \u2026 Saturday)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%w : num\u00e9ro du jour de la semaine (0=dimanche, 1=lundi, \u2026 6=samedi)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%X : num\u00e9ro de la semaine de l\u2019ann\u00e9e avec 4 digits, pour lequel le dimanche est le premier jour de la semaine (utilis\u00e9 avec %V)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%x : num\u00e9ro de la semaine de l\u2019ann\u00e9e avec 4 digits, pour lequel le lundi est le premier jour de la semaine (utilis\u00e9 avec %v)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%Y : ann\u00e9e, num\u00e9rique (avec 4 digits)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">%y : ann\u00e9e, num\u00e9rique (avec 2 digits)<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3304cc7 elementor-widget elementor-widget-image\" data-id=\"3304cc7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/date_format2.png\" class=\"attachment-full size-full wp-image-198516\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/date_format2.png 800w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/date_format2-300x169.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/date_format2-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b86aa6c elementor-widget elementor-widget-heading\" data-id=\"b86aa6c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">4 exemples de format de date avec la requ\u00eate SQL<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1cad25f elementor-widget elementor-widget-text-editor\" data-id=\"1cad25f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">La grande diversit\u00e9 des formats propos\u00e9s ci-dessus vous permet d<\/span><b>\u2019utiliser les combinaisons qui vous semblent les plus pertinentes<\/b><span style=\"font-weight: 400;\"> pour votre organisation (notamment au regard des habitudes culturelles des collaborateurs).\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour vous aider \u00e0 mieux comprendre, voici quelques exemples d\u2019utilisation de la requ\u00eate DATEFORMAT SQL :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SELECT DATE_FORMAT(\u201c2023-01-01\u201d, \u00ab\u00a0%D %b %Y\u00a0\u00bb) -&gt; 1st Jan 2023<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SELECT DATE_FORMAT(\u201c2023-01-01\u201d, \u00ab\u00a0%M %d %Y\u00a0\u00bb) -&gt; January 01 2023<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SELECT DATE_FORMAT(\u201c2023-01-01\u201d, \u00ab\u00a0%W %M %e %Y\u00a0\u00bb) -&gt; Sunday January 1 2023<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SELECT DATE_FORMAT(\u201c2023-01-01\u201d, \u00ab\u00a0%d\/%m\/%Y\u00a0\u00bb) -&gt; 01\/01\/2023<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b2858f0 elementor-widget elementor-widget-text-editor\" data-id=\"b2858f0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Afin de favoriser l\u2019uniformisation des donn\u00e9es au sein de l\u2019organisation, nous vous conseillons d\u2019indiquer le bon format au sein de votre strat\u00e9gie de data gouvernance.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1cf7870 e-flex e-con-boxed e-con\" data-id=\"1cf7870\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9d99931 elementor-widget elementor-widget-heading\" data-id=\"9d99931\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Quelles sont les autres fonctions de manipulations des dates ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c137093 elementor-widget elementor-widget-text-editor\" data-id=\"c137093\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Au-del\u00e0 de la requ\u00eate DATEFORMAT SQL, il est possible d\u2019utiliser d\u2019autres fonctions de date. Les voici :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">NOW() : cela permet d\u2019obtenir la date et l\u2019heure actuelle sous le format\u00a0 YYYYMMDDHHMMSS ou AAA-MM-JJ:HH:SS.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">CURDATE() : cela permet d\u2019obtenir la date actuelle sous le format YYYYMMDD ou AAA-MM-JJ.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">CURTIME () :cela permet d\u2019obtenir l\u2019heure actuelle sous le format HHMMSS ou HH-MM-SS.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">DATE_ADD : il s\u2019agit d\u2019ajouter un intervalle de temps \u00e0 une date (comme une microseconde, une seconde, une heure, un jour, une semaine, une ann\u00e9e, etc.).<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">DATE_SUB : \u00e0 l\u2019inverse, vous soustrayez un intervalle de temps \u00e0 une date.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">DATEDIFF : cette requ\u00eate SQL vous permet de calculer le nombre de jours entre deux dates distinctes.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\">SET DATE FORMAT : cela permet d\u2019obtenir la date sous le format <span>jour\/mois\/ann\u00e9e.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9d39133 e-flex e-con-boxed e-con\" data-id=\"9d39133\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d6f0b88 elementor-widget elementor-widget-heading\" data-id=\"d6f0b88\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Ce qu\u2019il faut retenir<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-86ed659 elementor-widget elementor-widget-text-editor\" data-id=\"86ed659\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Le requ\u00eate DATEFORMAT SQL permet d\u2019uniformiser les dates au sein d\u2019une base de donn\u00e9es.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Pour cela, il est possible d\u2019utiliser une multitude de formats. \u00c0 d\u00e9finir au sein de votre strat\u00e9gie de gouvernance de donn\u00e9es.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cela participe pleinement au nettoyage des donn\u00e9es et \u00e0 leur harmonisation. <\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b6ecfb5 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"b6ecfb5\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Se former au langage SQL<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e722750 e-flex e-con-boxed e-con\" data-id=\"e722750\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dccb9e1 elementor-widget elementor-widget-html\" data-id=\"dccb9e1\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Pourquoi uniformiser les dates ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"L\u2019uniformisation des dates s\u2019int\u00e8gre parfaitement dans l\u2019uniformisation des donn\u00e9es de votre database. En effet, les organisations disposent d\u2019un volume de donn\u00e9es de plus en plus cons\u00e9quent. Mais comme les sources et les formats sont extr\u00eamement vari\u00e9s, il est parfois difficile de les exploiter. Alors pour apporter plus de valeur gr\u00e2ce aux donn\u00e9es, il est primordial de les harmoniser. Afin de mener \u00e0 bien ce travail de standardisation, les organisations ont tout int\u00e9r\u00eat \u00e0 d\u00e9finir une strat\u00e9gie de gouvernance des donn\u00e9es.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment fonctionne la requ\u00eate DATEFORMAT-SQL ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La requ\u00eate DATE_FORMAT SQL permet de formater une date dans un format sp\u00e9cifique. C\u2019est la fonction \u00e0 privil\u00e9gier si vous souhaitez uniformiser les dates de l\u2019ensemble des donn\u00e9es.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>En fonction des pays, des cultures ou des sources de donn\u00e9es, les dates peuvent \u00eatre \u00e9crites d\u2019une multitude de mani\u00e8res. Or, pour simplifier le traitement des donn\u00e9es, il est primordial de les uniformiser. Mais alors comment uniformiser ces dates ? Gr\u00e2ce au langage informatique SQL, il est possible d\u2019utiliser la requ\u00eate DATEFORMAT SQL. Pourquoi uniformiser [&hellip;]<\/p>\n","protected":false},"author":78,"featured_media":198500,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Dateformat SQL : Tout savoir de cette requ\u00eate<\/title>\n<meta name=\"description\" content=\"Gr\u00e2ce \u00e0 la requ\u00eate DATEFORMAT SQL, vous pouvez uniformiser toutes les dates de votre base de donn\u00e9es. D\u00e9couvrez un peu plus sur cette fonction dans cet article.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/dateformat-sql-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dateformat SQL : Tout savoir de cette requ\u00eate\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/dateformat-sql-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-02T07:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:44:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/date_format_datascientest.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00e9my Robert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00e9my Robert\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/dateformat-sql-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/dateformat-sql-tout-savoir\",\"name\":\"Dateformat SQL : Tout savoir de cette requ\u00eate\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-08-02T07:30:00+00:00\",\"dateModified\":\"2023-11-09T13:44:05+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\"},\"description\":\"Gr\u00e2ce \u00e0 la requ\u00eate DATEFORMAT SQL, vous pouvez uniformiser toutes les dates de votre base de donn\u00e9es. D\u00e9couvrez un peu plus sur cette fonction dans cet article.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/dateformat-sql-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\",\"name\":\"J\u00e9r\u00e9my Robert\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"caption\":\"J\u00e9r\u00e9my Robert\"},\"description\":\"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jeremyrobert1\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/jeremyrobert\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Dateformat SQL : Tout savoir de cette requ\u00eate","description":"Gr\u00e2ce \u00e0 la requ\u00eate DATEFORMAT SQL, vous pouvez uniformiser toutes les dates de votre base de donn\u00e9es. D\u00e9couvrez un peu plus sur cette fonction dans cet article.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/dateformat-sql-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"Dateformat SQL : Tout savoir de cette requ\u00eate","og_url":"https:\/\/datascientest.com\/dateformat-sql-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-08-02T07:30:00+00:00","article_modified_time":"2023-11-09T13:44:05+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/date_format_datascientest.png","type":"image\/png"}],"author":"J\u00e9r\u00e9my Robert","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"J\u00e9r\u00e9my Robert","Dur\u00e9e de lecture estim\u00e9e":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/dateformat-sql-tout-savoir","url":"https:\/\/datascientest.com\/dateformat-sql-tout-savoir","name":"Dateformat SQL : Tout savoir de cette requ\u00eate","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-08-02T07:30:00+00:00","dateModified":"2023-11-09T13:44:05+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925"},"description":"Gr\u00e2ce \u00e0 la requ\u00eate DATEFORMAT SQL, vous pouvez uniformiser toutes les dates de votre base de donn\u00e9es. D\u00e9couvrez un peu plus sur cette fonction dans cet article.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/dateformat-sql-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925","name":"J\u00e9r\u00e9my Robert","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","caption":"J\u00e9r\u00e9my Robert"},"description":"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.","sameAs":["https:\/\/www.linkedin.com\/in\/jeremyrobert1\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/jeremyrobert"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/198498"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=198498"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/198498\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/198500"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=198498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=198498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=198498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}