{"id":30604,"date":"2024-03-11T06:41:00","date_gmt":"2024-03-11T05:41:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=30604"},"modified":"2024-03-13T12:27:43","modified_gmt":"2024-03-13T11:27:43","slug":"display-month-name-in-sql-server-in-different-languages","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/","title":{"rendered":"Display Month Name in SQL Server in Different Languages"},"content":{"rendered":"\n<p>Languages are a significant part of human history, culture, and communication and different languages offer unique insights into diverse worldviews and traditions. The following are ten of the most widely spoken languages around the world. Each language is accompanied by a T-SQL code snippet that formats a date to display the month name in that specific language.<\/p>\n\n\n\n<p>So, let&#8217;s break down the T-SQL code by language with a short description for each language. In a previous article we saw how to <a href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/\"><strong>display the month name using different T-SQL variations<\/strong><\/a>, without changing the language.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#1-display-month-name-using-sql-server-in-chinese-mandarin\" >1. Display month name using SQL Server in Chinese (Mandarin)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#2-spanish\" >2. Spanish<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#3-display-the-month-name-in-english-using-t-sql\" >3. Display the month name in English using T-SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#4-hindi\" >4. Hindi<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#5-month-name-in-arabic-using-t-sql\" >5. Month name in Arabic using T-SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#6-portuguese\" >6. Portuguese<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#7-bengali\" >7. Bengali<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#8-russian\" >8. Russian<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#9-japanese\" >9. Japanese<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#10-month-name-in-lahnda-western-punjabi\" >10. Month name in Lahnda (Western Punjabi)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#11-t-sql-query-to-get-the-month-name-in-multiple-languages-at-once\" >11. T-SQL query to get the month name in multiple languages at once<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-display-month-name-using-sql-server-in-chinese-mandarin\"><span class=\"ez-toc-section\" id=\"1-display-month-name-using-sql-server-in-chinese-mandarin\"><\/span>1. Display month name using SQL Server in Chinese (Mandarin)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Chinese is the official language of China and also Taiwan. Displaying month names in Chinese (Mandarin) within SQL Server requires an understanding of its linguistic nuances. Mandarin Chinese, serving as the official language of both China and Taiwan, holds significant global importance.<\/p>\n\n\n\n<p>In SQL Server, formatting dates to display month names in Mandarin involves utilizing language-specific functions and character sets, ensuring accurate representation within database systems.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @date datetime = '2023-01-01';\nSELECT FORMAT(@date, 'MMMM', 'zh-CN') AS 'zh-CN'; -- Chinese (Mandarin)\n<\/pre>\n\n\n\n<p>Explanation of the query:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Within the <strong>SELECT <\/strong>statement, the <strong>FORMAT <\/strong>function is utilized to format the date stored in the <em>@date<\/em> variable.<\/li>\n\n\n\n<li>The second parameter, <strong>&#8216;MMMM&#8217;,<\/strong> specifies the format of the output, indicating the full name of the month.<\/li>\n\n\n\n<li>Third parameter is <strong>&#8216;zh-CN&#8217;<\/strong>, represents the culture or language for formatting, specifically Chinese (Mandarin) spoken in China.<\/li>\n\n\n\n<li>The <strong>AS &#8216;zh-CN&#8217;<\/strong> part assigns the resulting formatted month name to the column name &#8216;zh-CN&#8217; in the output.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-spanish\"><span class=\"ez-toc-section\" id=\"2-spanish\"><\/span>2. Spanish<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The Spanish language is spoken in many countries, especially in Latin America and Spain.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @date datetime = '2023-01-01';\n\nSELECT FORMAT(@date, 'MMMM', 'es-ES') AS 'es-ES'; -- Spanish<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages-1024x576.png\" alt=\"Queries To Display Month Name in SQL Server in Top 10 Languages\" class=\"wp-image-30606\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages-1024x576.png 1024w, https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages-300x169.png 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages-768x432.png 768w, https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages-1536x864.png 1536w, https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Queries To Display Month Name in SQL Server in Top 10 Languages<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-display-the-month-name-in-english-using-t-sql\"><span class=\"ez-toc-section\" id=\"3-display-the-month-name-in-english-using-t-sql\"><\/span>3. Display the month name in English using T-SQL <span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>English is often described as a <em>global lingua franca<\/em>. This query is an example of how to display the name of the month in English (American) using SQL Server. By declaring a datetime variable and then utilizing the FORMAT function with the appropriate language code (&#8216;en-US&#8217;), the query outputs the month name in English, specifically in the American format.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @date datetime = '2023-01-01';\n\nSELECT FORMAT(@date, 'MMMM', 'en-US') AS 'en-US'; -- English American<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-hindi\"><span class=\"ez-toc-section\" id=\"4-hindi\"><\/span>4. Hindi<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Description<\/strong>: Predominantly spoken in India.<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @date datetime = '2023-01-01';\n\nSELECT FORMAT(@date, 'MMMM', 'hi-IN') AS 'hi-IN'; -- Hindi<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-5-month-name-in-arabic-using-t-sql\"><span class=\"ez-toc-section\" id=\"5-month-name-in-arabic-using-t-sql\"><\/span>5. Month name in Arabic using T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Description<\/strong>: Official language in 26 countries in the Middle East and Africa.<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @date datetime = '2023-01-01';\n\nSELECT FORMAT(@date, 'MMMM', 'ar-SA') AS 'ar-SA'; -- Arabic\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-6-portuguese\"><span class=\"ez-toc-section\" id=\"6-portuguese\"><\/span>6. Portuguese<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Description<\/strong>: Official language of Brazil and Portugal.<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @date datetime = '2023-01-01';\n\nSELECT FORMAT(@date, 'MMMM', 'pt-BR') AS 'pt-BR'; -- Portuguese (Brazil)\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-7-bengali\"><span class=\"ez-toc-section\" id=\"7-bengali\"><\/span>7. Bengali<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Description<\/strong>: Official language in Bangladesh and parts of India.<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @date datetime = '2023-01-01';\n\nSELECT FORMAT(@date, 'MMMM', 'bn-BD') AS 'bn-BD'; -- Bengali (Bangladesh)\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-8-russian\"><span class=\"ez-toc-section\" id=\"8-russian\"><\/span>8. Russian<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Description<\/strong>: Official language of Russia.<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @date datetime = '2023-01-01';\n\nSELECT FORMAT(@date, 'MMMM', 'ru-RU') AS 'ru-RU'; -- Russian\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-9-japanese\"><span class=\"ez-toc-section\" id=\"9-japanese\"><\/span>9. Japanese<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Description<\/strong>: Official language of Japan.<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @date datetime = '2023-01-01';\n\nSELECT FORMAT(@date, 'MMMM', 'ja-JP') AS 'ja-JP'; -- Japanese\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-10-month-name-in-lahnda-western-punjabi\"><span class=\"ez-toc-section\" id=\"10-month-name-in-lahnda-western-punjabi\"><\/span>10. Month name in Lahnda (Western Punjabi)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Description<\/strong>: Spoken primarily in the Punjab region of Pakistan.<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DECLARE @date datetime = '2023-01-01';\n\nSELECT FORMAT(@date, 'MMMM', 'pa-PK') AS 'pa-PK'; -- Punjabi (Pakistan)\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-11-t-sql-query-to-get-the-month-name-in-multiple-languages-at-once\"><span class=\"ez-toc-section\" id=\"11-t-sql-query-to-get-the-month-name-in-multiple-languages-at-once\"><\/span>11. T-SQL query to get the month name in multiple languages at once<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The code below, still uses the SQL Server&#8217;s FORMAT() function to extract the month name from a given date,  here it is <em>2023-12-31<\/em>. It generates a result set that displays the month&#8217;s name for this date across multiple prominent languages, such as Chinese (Mandarin), Spanish, English, and several others, all within a single query.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- ** Code by Expert-Only.com ** --\nDECLARE @date datetime = '2023-12-31';\n\nSELECT \n    FORMAT(@date, 'MMMM', 'zh-CN') AS 'zh-CN',  -- Chinese (Mandarin)\n    FORMAT(@date, 'MMMM', 'es-ES') AS 'es-ES',  -- Spanish\n    FORMAT(@date, 'MMMM', 'en-US') AS 'en-US',  -- English American\n    FORMAT(@date, 'MMMM', 'hi-IN') AS 'hi-IN',  -- Hindi\n    FORMAT(@date, 'MMMM', 'ar-SA') AS 'ar-SA',  -- Arabic\n    FORMAT(@date, 'MMMM', 'pt-BR') AS 'pt-BR',  -- Portuguese (Brazil)\n    FORMAT(@date, 'MMMM', 'bn-BD') AS 'bn-BD',  -- Bengali (Bangladesh)\n    FORMAT(@date, 'MMMM', 'ru-RU') AS 'ru-RU',  -- Russian\n    FORMAT(@date, 'MMMM', 'ja-JP') AS 'ja-JP',  -- Japanese\n    FORMAT(@date, 'MMMM', 'pa-PK') AS 'pa-PK';  -- Punjabi (Pakistan);\n<\/pre>\n\n\n\n<p>The result gives this result in SSMS:<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><thead><tr><th>zh-CN<\/th><th>es-ES<\/th><th>en-US<\/th><th>hi-IN<\/th><th>ar-SA<\/th><th>pt-BR<\/th><th>bn-BD<\/th><th>ru-RU<\/th><th>ja-JP<\/th><th>pa-PK<\/th><\/tr><\/thead><tbody><tr><td>\u5341\u4e8c\u6708<\/td><td>diciembre<\/td><td>December<\/td><td>\u0926\u093f\u0938\u092e\u094d\u092c\u0930<\/td><td>\u062c\u0645\u0627\u062f\u0649 \u0627\u0644\u062b\u0627\u0646\u064a\u0629<\/td><td>dezembro<\/td><td>\u09a1\u09bf\u09b8\u09c7\u09ae\u09cd\u09ac\u09b0<\/td><td>\u0414\u0435\u043a\u0430\u0431\u0440\u044c<\/td><td>12\u6708<\/td><td>\u0a26\u0a38\u0a70\u0a2c\u0a30<\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\"><em>Month translated in the World top 10 languages using FORMAT and ISO country codes<\/em><\/figcaption><\/figure>\n\n\n\n<p>Note the specificities for Arabic, the month name &#8220;\u062c\u0645\u0627\u062f\u0649 \u0627\u0644\u062b\u0627\u0646\u064a\u0629&#8221; is not December in Arabic; it refers to a month in the Islamic lunar calendar. And in the <a href=\"https:\/\/www.thefreedictionary.com\/Gregorian+calendar+month\">Gregorian calendar<\/a>, December is represented as &#8220;\u062f\u064a\u0633\u0645\u0628\u0631&#8221; in Arabic.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-sql-server-and-multilingual-month-display-challenges\">SQL Server and Multilingual Month Display challenges<\/h3>\n\n\n\n<p>In summary, this article explains the SQL Server functionality to display month name in the top 10 languages globally most spoken. Through the examination of language-specific T-SQL code snippets, we&#8217;ve highlighted the platform&#8217;s capability to accommodate diverse linguistic needs. This analysis emphasizes the practical importance of language support within database systems, facilitating efficient data management in multilingual environments.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Languages are a significant part of human history, culture, and communication and different languages offer unique insights into diverse worldviews and traditions. The following are ten of the most widely spoken languages around the world. Each language is accompanied <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/\" title=\"Display Month Name in SQL Server in Different Languages\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":30606,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[454],"tags":[],"class_list":{"0":"post-30604","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Display Month Name in SQL Server in Different Languages - T-SQL<\/title>\n<meta name=\"description\" content=\"SQL Server queries to display the month name in different languages, we chose the top 10 most spoken languages in the world.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Display Month Name in SQL Server in Different Languages\" \/>\n<meta property=\"og:description\" content=\"SQL Server queries to display the month name in different languages, we chose the top 10 most spoken languages in the world.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-11T05:41:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-13T11:27:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Display Month Name in SQL Server in Different Languages\",\"datePublished\":\"2024-03-11T05:41:00+00:00\",\"dateModified\":\"2024-03-13T11:27:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/\"},\"wordCount\":670,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages.png\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/\",\"url\":\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/\",\"name\":\"Display Month Name in SQL Server in Different Languages - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages.png\",\"datePublished\":\"2024-03-11T05:41:00+00:00\",\"dateModified\":\"2024-03-13T11:27:43+00:00\",\"description\":\"SQL Server queries to display the month name in different languages, we chose the top 10 most spoken languages in the world.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages.png\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages.png\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Display Month Name in SQL Server in Different Languages\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Display Month Name in SQL Server in Different Languages - T-SQL","description":"SQL Server queries to display the month name in different languages, we chose the top 10 most spoken languages in the world.","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:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/","og_locale":"en_US","og_type":"article","og_title":"Display Month Name in SQL Server in Different Languages","og_description":"SQL Server queries to display the month name in different languages, we chose the top 10 most spoken languages in the world.","og_url":"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-11T05:41:00+00:00","article_modified_time":"2024-03-13T11:27:43+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages.png","type":"image\/png"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Display Month Name in SQL Server in Different Languages","datePublished":"2024-03-11T05:41:00+00:00","dateModified":"2024-03-13T11:27:43+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/"},"wordCount":670,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages.png","articleSection":["T-SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/","url":"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/","name":"Display Month Name in SQL Server in Different Languages - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages.png","datePublished":"2024-03-11T05:41:00+00:00","dateModified":"2024-03-13T11:27:43+00:00","description":"SQL Server queries to display the month name in different languages, we chose the top 10 most spoken languages in the world.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages.png","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/03\/world-cup-flags-display-month-name-10-languages.png","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-different-languages\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Display Month Name in SQL Server in Different Languages"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/30604","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=30604"}],"version-history":[{"count":5,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/30604\/revisions"}],"predecessor-version":[{"id":30665,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/30604\/revisions\/30665"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/30606"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=30604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=30604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=30604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}