{"id":174180,"date":"2023-11-27T19:34:15","date_gmt":"2023-11-27T18:34:15","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=174180"},"modified":"2023-11-27T19:36:21","modified_gmt":"2023-11-27T18:36:21","slug":"sql-dateformat-learn-all-about-this-query","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query","title":{"rendered":"SQL Dateformat : Learn all about this query"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"174180\" class=\"elementor elementor-174180\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1de2aaa e-flex e-con-boxed e-con\" data-id=\"1de2aaa\" 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-d34bebc elementor-widget elementor-widget-heading\" data-id=\"d34bebc\" 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\">Depending on the country, culture or data source, dates can be written in a multitude of ways. To simplify data processing, it is essential to standardize them. So how do you standardize dates? Thanks to the computer language SQL, it's possible to use the DATEFORMAT SQL query. <\/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-029120c e-flex e-con-boxed e-con\" data-id=\"029120c\" 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-525e42c elementor-widget elementor-widget-heading\" data-id=\"525e42c\" 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\">Standardizing data to make better use of it<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-42ba7b2 elementor-widget elementor-widget-text-editor\" data-id=\"42ba7b2\" 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>Date standardization fits in perfectly with the <a href=\"https:\/\/datascientest.com\/en\/all-about-non-relational-databases\">standardization of your database data.<\/a><\/p><p>Organizations have an ever-increasing volume of data at their disposal. But as the sources and formats are extremely varied, it can sometimes be difficult to exploit them. So, to bring more value from data, it&#8217;s vital to harmonize it.<\/p><p>To achieve this standardization, organizations need to define a <a href=\"https:\/\/datascientest.com\/en\/talend-the-tool-of-choice-for-integrating-your-data\">data governance strategy.<\/a><\/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-eabc53f elementor-widget elementor-widget-heading\" data-id=\"eabc53f\" 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\">Uniform dates<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f24648b elementor-widget elementor-widget-text-editor\" data-id=\"f24648b\" 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>If data standardization is crucial for companies, it&#8217;s even more important for dates. All data is integrated on a specific day and time. Knowing this date can have an impact on decision-making. It is therefore essential that they are harmonized throughout the organization.<\/p><p>In practice, however, this is far from always being the case.<\/p><p>Firstly, because data comes from a multitude of sources (social networks, websites, reports, etc.).<\/p><p>Secondly, because each country has its own formatting. For example, April 18, 2023 will be written differently in different countries:<\/p><ul><li>in France: 18\/04\/2023<\/li><li>United States: 04\/18\/2023<\/li><li>China: 2023\/18\/04<\/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-338b885 elementor-widget elementor-widget-text-editor\" data-id=\"338b885\" 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>Between the diversity of data sources and cultures, the format of dates is very often heterogeneous. This is why the <strong>DATEFORMAT SQL<\/strong> query is so useful. Its aim is to provide all database users with a date format that is easy to read and understand by all. So how does it work?<\/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-cdbd381 elementor-widget elementor-widget-image\" data-id=\"cdbd381\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/date_format1.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-ae1f76a elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"ae1f76a\" 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\/en\/data-scientist-course\">\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\">Learn to use SQL queries<\/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-cb1b1be e-flex e-con-boxed e-con\" data-id=\"cb1b1be\" 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-60755fa elementor-widget elementor-widget-heading\" data-id=\"60755fa\" 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\">How does a DATEFORMAT-SQL query work?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4971043 elementor-widget elementor-widget-text-editor\" data-id=\"4971043\" 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>The <strong>DATE_FORMAT SQL query<\/strong> allows you to format a date in a specific format. This is the function of choice if you want to standardize dates across all your data.<\/p><p>Here&#8217;s how it works:<\/p><p><strong>SELECT DATE_FORMAT(date,format)<\/strong><\/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-8859a92 elementor-widget elementor-widget-heading\" data-id=\"8859a92\" 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\">Formats<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f663146 elementor-widget elementor-widget-text-editor\" data-id=\"f663146\" 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>For the format, you can choose a character string from the list below:<\/p><p><br \/>%a: abbreviated weekday name (Sun, Mon, &#8230; Sat)<br \/>%b: abbreviated month name (Jan, Feb, &#8230; Dec)<br \/>%c: month number (0, 1, 2, &#8230; 12)<br \/>%D: day number, with English suffix (0th, 1st, 2nd, 3rd, &#8230;)<br \/>%d: number of the day of the month, to 2 decimal places (00..31) <br \/>%e: number of the day of the month (0..31) <br \/>%f: microseconds (000000..999999)<br \/>%H: hour (00..23)<br \/>%h: hour (01..12)<br \/>%I: hour (01..12)<br \/>%i: minutes (00..59) <br \/>%j: day of year (001..366)<br \/>%k: hour (0..23)<br \/>%l: hour (1..12)<br \/>%M: month name in English (January, February, &#8230;December)<br \/>%m: month (00..12) <br \/>%p: AM or PM<br \/>%r: time in 12-hour format (hh:mm:ss followed by AM or PM)<br \/>%S: seconds (00..59)<br \/>%s: seconds (00..59)<br \/>%T: time in 24-hour format (hh:mm:ss)<br \/>%U: Week (00..53), where Sunday is the first day of the week; WEEK() mode 0<br \/>%u: Week (00..53), for which Monday is the first day of the week<br \/>%V : Week (01..53), for which Sunday is the first day of the week (used with %X)<br \/>%v: Week (01..53), for which Monday is the first day of the week; (used with %x)<br \/>%W: name of the day of the week (Sunday, Monday, &#8230; Saturday)<br \/>%w: number of the day of the week (0=Sunday, 1=Monday, &#8230; 6=Saturday)<br \/>%X: number of the week of the year with 4 digits, for which Sunday is the first day of the week (used with %V)<br \/>%x: number of the week of the year with 4 digits, for which Monday is the first day of the week (used with %v)<br \/>%Y: year, numeric (with 4 digits)<br \/>%y: year, numeric (2-digit)<\/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-883071e elementor-widget elementor-widget-image\" data-id=\"883071e\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/date_format2.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-22339cb elementor-widget elementor-widget-heading\" data-id=\"22339cb\" 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 examples of date format with SQL query<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-213c291 elementor-widget elementor-widget-text-editor\" data-id=\"213c291\" 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>The <strong>wide variety of formats<\/strong> suggested above enables you to use the combinations that seem most relevant to your organization (particularly with regard to the cultural habits of your employees).<\/p><p>To help you understand, here are a few examples of how to use the <strong>DATEFORMAT SQL<\/strong> query:<\/p><p>SELECT DATE_FORMAT(&#8220;2023-01-01&#8221;, &#8220;%D %b %Y&#8221;) -&gt; 1st Jan 2023<br \/>SELECT DATE_FORMAT(&#8220;2023-01-01&#8221;, &#8220;%M %d %Y&#8221;) -&gt; January 01 2023<br \/>SELECT DATE_FORMAT(&#8220;2023-01-01&#8221;, &#8220;%W %M %e %Y&#8221;) -&gt; Sunday January 1 2023<br \/>SELECT DATE_FORMAT(&#8220;2023-01-01&#8221;, &#8220;%d\/%m\/%Y&#8221;) -&gt; 01\/01\/2023<\/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-1a87ae3 elementor-widget elementor-widget-text-editor\" data-id=\"1a87ae3\" 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>To promote data standardization across the organization, we recommend that you specify the correct format as part of your data governance strategy.<\/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-313ff60 e-flex e-con-boxed e-con\" data-id=\"313ff60\" 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-9935111 elementor-widget elementor-widget-heading\" data-id=\"9935111\" 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\">What are the other date management functions?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-afd287c elementor-widget elementor-widget-text-editor\" data-id=\"afd287c\" 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>In addition to the DATEFORMAT SQL query, you can also use other date functions as <a href=\"https:\/\/datascientest.com\/en\/sql-queries-the-5-most-important-commands-to-know\">SQL queries.<\/a> These are as follows:<\/p><ul><li>NOW(): this returns the current date and time in YYYYMMDDHHMMSS or YYYY-MM-DD:HH:SS format.<\/li><li>CURDATE() : displays the current date in YYYYMMDD or YYYY-MM-DD format.<\/li><li>CURTIME(): this gives the current time in HHMMSS or HH-MM-SS format.<\/li><li>DATE_ADD: this adds a time interval to a date (such as a microsecond, a second, an hour, a day, a week, a year, etc.).<\/li><li>DATE_SUB: conversely, you subtract a time interval from a date.<\/li><li>DATEDIFF: this SQL query allows you to calculate the number of days between two distinct dates.<\/li><li>SET DATE FORMAT: this allows you to obtain the date in day\/month\/year format.<\/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-221b13e e-flex e-con-boxed e-con\" data-id=\"221b13e\" 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-6c0d4f2 elementor-widget elementor-widget-heading\" data-id=\"6c0d4f2\" 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\">Things to remember<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4f3b50f elementor-widget elementor-widget-text-editor\" data-id=\"4f3b50f\" 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\">The DATEFORMAT SQL query is used to <a href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\">standardize dates within a database.<\/a><\/li><li style=\"font-weight: 400;\" aria-level=\"1\">A multitude of formats can be used. To be defined as part of your data governance strategy.<\/li><li style=\"font-weight: 400;\" aria-level=\"1\">This plays a key role in cleansing and harmonizing data.<\/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-98576b7 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"98576b7\" 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\/en\/data-scientist-course\">\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\">Learn 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-acafca6 e-flex e-con-boxed e-con\" data-id=\"acafca6\" 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-0d8a6fc elementor-widget elementor-widget-html\" data-id=\"0d8a6fc\" 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\">\n{\n  \"@context\" : \"https:\/\/schema.org\",\n  \"@type\" : \"FAQPage\",\n  \"mainEntity\" : [{\n    \"@type\" : \"Question\",\n    \"name\" : \"SQL DISTINCT pour \u00e9liminer les doublons\",\n    \"acceptedAnswer\" : {\n      \"@type\" : \"R\u00e9ponse\",\n      \"text\" : \"La requ\u00eate SQL DISTINCT peut \u00eatre utilis\u00e9e pour limiter les doublons. Lorsque tu utilises la commande de l'instruction SELECT, tu peux s\u00e9lectionner une ou plusieurs colonnes de la table. Mais \u00e0 l'int\u00e9rieur de ces colonnes, il peut y avoir des lignes en double. Pour \u00e9viter cela, tu dois ajouter DISTINCT \u00e0 la requ\u00eate SELECT. Ce faisant, toutes les redondances sont \u00e9limin\u00e9es.\"\n    }\n  },{\n    \"@type\" : \"Question\",\n    \"name\" : \"Alternatives \u00e0 SQL DISTINCT\",\n    \"acceptedAnswer\" : {\n      \"@type\" : \"R\u00e9ponse\",\n      \"text\" : \"D'autres commandes peuvent \u00eatre utilis\u00e9es pour \u00e9liminer les doublons. En particulier GROUP BY \/ ORDER BY.\"\n    }\n  }]\n}\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>Depending on the country, culture or data source, dates can be written in a multitude of ways. To simplify data processing, it is essential to standardize them. So how do you standardize dates? Thanks to the computer language SQL, it&#8217;s possible to use the DATEFORMAT SQL query. Standardizing data to make better use of it [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":174182,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"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>SQL Dateformat : Learn all about this query<\/title>\n<meta name=\"description\" content=\"The SQL Dateformat query in SQL is not a standard SQL query itself, but it&#039;s commonly used with SQL databases to format dates in a specific way when\" \/>\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\/en\/sql-dateformat-learn-all-about-this-query\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Dateformat : Learn all about this query\" \/>\n<meta property=\"og:description\" content=\"Depending on the country, culture or data source, dates can be written in a multitude of ways. To simplify data processing, it is essential to standardize\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-27T18:34:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-27T18:36:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/dateformat.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"SQL Dateformat : Learn all about this query\",\"datePublished\":\"2023-11-27T18:34:15+00:00\",\"dateModified\":\"2023-11-27T18:36:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query\"},\"wordCount\":867,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query\",\"url\":\"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query\",\"name\":\"SQL Dateformat : Learn all about this query\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-11-27T18:34:15+00:00\",\"dateModified\":\"2023-11-27T18:36:21+00:00\",\"description\":\"The SQL Dateformat query in SQL is not a standard SQL query itself, but it's commonly used with SQL databases to format dates in a specific way when\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Dateformat : Learn all about this query","description":"The SQL Dateformat query in SQL is not a standard SQL query itself, but it's commonly used with SQL databases to format dates in a specific way when","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\/en\/sql-dateformat-learn-all-about-this-query","og_locale":"en_GB","og_type":"article","og_title":"SQL Dateformat : Learn all about this query","og_description":"Depending on the country, culture or data source, dates can be written in a multitude of ways. To simplify data processing, it is essential to standardize","og_url":"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-11-27T18:34:15+00:00","article_modified_time":"2023-11-27T18:36:21+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2023\/11\/dateformat.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"SQL Dateformat : Learn all about this query","datePublished":"2023-11-27T18:34:15+00:00","dateModified":"2023-11-27T18:36:21+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query"},"wordCount":867,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query","url":"https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query","name":"SQL Dateformat : Learn all about this query","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-11-27T18:34:15+00:00","dateModified":"2023-11-27T18:36:21+00:00","description":"The SQL Dateformat query in SQL is not a standard SQL query itself, but it's commonly used with SQL databases to format dates in a specific way when","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/sql-dateformat-learn-all-about-this-query"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/174180"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=174180"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/174180\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/174182"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=174180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=174180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=174180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}