{"id":6417,"date":"2023-12-18T06:25:00","date_gmt":"2023-12-18T05:25:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=6417"},"modified":"2024-03-12T09:28:16","modified_gmt":"2024-03-12T08:28:16","slug":"how-to-display-month-name-in-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/","title":{"rendered":"How To Display Month Name In SQL Server ?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\"><strong><em>To display the full month name in all letters from a date using a SQL Server query?<\/em><\/strong><\/h4>\n\n\n\n<p>The SQL Server database offers T-SQL methods to display the month name in diverse formats, including name in all letters, abbreviations, and in multiple languages. The DATENAME() function, combined with the MONTH keyword for example, is commonly used to fetch and format month names. Indeed, the 2 native functions: DATENAME() and FORMAT(), are the primary recommended methods to use in native T-SQL to get the month&#8217;s name in letters.<\/p>\n\n\n\n<p>Indeed, in T-SQL, there are a few functions you can use to display the month name in letters:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>DATENAME()<\/strong>: This function returns a character string representing the specified <em>datepart<\/em> of the specified date.<\/li>\n\n\n\n<li><strong>FORMAT()<\/strong>: While primarily designed for formatting, you can use this function to get the month name in letters, especially when dealing with different languages or locales.<\/li>\n<\/ol>\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\/how-to-display-month-name-in-sql-server\/#1-t-sql-query-to-display-the-month-name-from-the-current-date\" >1. T-SQL query to display the month name from the current date<\/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\/how-to-display-month-name-in-sql-server\/#2-get-month-name-in-all-letters-from-a-date-in-sql-server\" >2. Get month name in all letters from a date in SQL Server<\/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\/how-to-display-month-name-in-sql-server\/#3-display-the-month-name-abbreviation-with-t-sql\" >3. Display the month name abbreviation with 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\/how-to-display-month-name-in-sql-server\/#4-display-the-month-number-using-t-sql-datepart-function\" >4. Display the month number using T-SQL DATEPART function<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-t-sql-query-to-display-the-month-name-from-the-current-date\"><span class=\"ez-toc-section\" id=\"1-t-sql-query-to-display-the-month-name-from-the-current-date\"><\/span>1. T-SQL query to display the month name from the current date<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The query below simply shows the month name using the MONTH option and the current timestamp with the default output 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=\"\">SELECT DATENAME(MONTH, GETDATE() ) AS [MonthName],\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0GETDATE() AS [CurrentDate];\n<\/pre>\n\n\n\n<p>For example, it returns &#8220;June&#8221; in all letters for today.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/expert-only.net\/wp-content\/uploads\/2017\/06\/Month-Name-Letters-SQL-Server.png\" alt=\"Display the month name in SQL Server using the DATENAME time function\" class=\"wp-image-410\"\/><figcaption class=\"wp-element-caption\"><em>How To Display Month Name In SQL Server ?<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Another post from the blog is about date and time and shows how to <a href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-calculate-difference-between-two-dates-in-t-sql\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>calculate a date difference with the hours, minutes and seconds<\/strong><\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-get-month-name-in-all-letters-from-a-date-in-sql-server\"><\/span>2. Get month name in all letters from a date in SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>One way to display the month name in SQL Server is by showing the full month name in English. This method can be helpful in situations where you need to display the month name in a more formal manner, such as in a report or a document. By using the DATENAME() function with the MONTH keyword and the FORMAT() function with the &#8216;MMMM&#8217; specifier, you can easily retrieve the full month name in English. This query simply returns the full month name, such as &#8220;January&#8221; or &#8220;December&#8221;.<\/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=\"\">SELECT FORMAT(GETDATE(), 'MMMM') AS [FullMonthName];<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-display-the-month-name-abbreviation-with-t-sql\"><\/span>3. Display the month name abbreviation with T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To display the month abbreviation in SQL Server, you can utilize the DATENAME() function paired with the MONTH keyword or the FORMAT() function using the &#8216;MMM&#8217; specifier. This method, producing results like &#8220;Jan&#8221; or &#8220;Dec&#8221;, is particularly beneficial for concise representations in tables or charts. It&#8217;s also advantageous when dates need to be grouped by month, offering a succinct categorization. Below is the illustrative code example to achieve this:<\/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=\"\">SELECT FORMAT(DATENAME(MONTH, GETDATE()), 'MMM') AS [MonthAbbreviation];<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-display-the-month-number-using-t-sql-datepart-function\"><\/span>4. Display the month number using T-SQL DATEPART function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This time, to do the opposite operation, i.e. display the month number in SQL Server, use the DATEPART() function with the MONTH keyword. This returns the month as an integer, from 1 for January to 12 for December. This method is useful for calculations or also sorting data in result queries for example.<\/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=\"\">SELECT DATEPART(MONTH, GETDATE()) AS [MonthNumber];\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Different ways to display the month name using SQL Server<\/h3>\n\n\n\n<p>In SQL Server, various built-in functions enable you to display month names in different formats, including full names, abbreviations, or numerical representations. The <code>FORMAT()<\/code> function allows for language-specific month naming. These tools are invaluable for reporting, charting, or month-based calculations.<\/p>\n\n\n\n<p>This guide provides insights into showcasing month names effectively in SQL Server. For further precision, like calculating the exact time difference between two dates, refer to our tutorial on date difference in SQL Server. Another common challenge is <a href=\"https:\/\/expert-only.com\/en\/t-sql\/calculate-difference-between-two-dates\/\">to calculate the time difference between two dates, with accuracy<\/a>, i.e. including the hours, minutes, seconds and sometime milliseconds.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"DVdsn34G3c\"><a href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-calculate-difference-between-two-dates-in-t-sql\/\">How to Calculate Difference Between Two Dates in T-SQL ?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;How to Calculate Difference Between Two Dates in T-SQL ?&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-calculate-difference-between-two-dates-in-t-sql\/embed\/#?secret=1SsLN3tOju#?secret=DVdsn34G3c\" data-secret=\"DVdsn34G3c\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h5 class=\"wp-block-heading\">Display the month name is different languages<\/h5>\n\n\n\n<p>To go further and learn how to display the month name in different languages, check out this <a href=\"https:\/\/expert-only.com\/en\/t-sql\/display-month-name-in-sql-server-in-top-10-languages\/\" data-type=\"post\" data-id=\"30604\"><strong>T-SQL query to get the month in the 10 major languages worldwide<\/strong><\/a>. Below is an overview of how to build such a query using the FORMAT function.<\/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'; SELECT FORMAT(@date, 'MMMM', 'es-ES') AS 'es-ES'; -- Spanish<\/pre>\n\n\n\n<p><strong><em>Please do not hesitate to leave a comment or to contact us.<\/em><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>To display the full month name in all letters from a date using a SQL Server query? The SQL Server database offers T-SQL methods to display the month name in diverse formats, including name in all letters, abbreviations, and <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/\" title=\"How To Display Month Name In SQL Server ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":6406,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[454],"tags":[],"class_list":{"0":"post-6417","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>How To Display Month Name In SQL Server ? T-SQL<\/title>\n<meta name=\"description\" content=\"To display the month name from a date or from the month number in SQL Server, use a query with the time functions and pick a format.\" \/>\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\/how-to-display-month-name-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Display Month Name In SQL Server ?\" \/>\n<meta property=\"og:description\" content=\"To display the month name from a date or from the month number in SQL Server, use a query with the time functions and pick a format.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/\" \/>\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=\"2023-12-18T05:25:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-12T08:28:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/agenda-2296195_1920.jpg\" \/>\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\/jpeg\" \/>\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\/how-to-display-month-name-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"How To Display Month Name In SQL Server ?\",\"datePublished\":\"2023-12-18T05:25:00+00:00\",\"dateModified\":\"2024-03-12T08:28:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/\"},\"wordCount\":638,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/agenda-2296195_1920.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/\",\"name\":\"How To Display Month Name In SQL Server ? T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/agenda-2296195_1920.jpg\",\"datePublished\":\"2023-12-18T05:25:00+00:00\",\"dateModified\":\"2024-03-12T08:28:16+00:00\",\"description\":\"To display the month name from a date or from the month number in SQL Server, use a query with the time functions and pick a format.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/agenda-2296195_1920.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/agenda-2296195_1920.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Display Month Name In SQL Server ?\"}]},{\"@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":"How To Display Month Name In SQL Server ? T-SQL","description":"To display the month name from a date or from the month number in SQL Server, use a query with the time functions and pick a format.","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\/how-to-display-month-name-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How To Display Month Name In SQL Server ?","og_description":"To display the month name from a date or from the month number in SQL Server, use a query with the time functions and pick a format.","og_url":"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-12-18T05:25:00+00:00","article_modified_time":"2024-03-12T08:28:16+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/agenda-2296195_1920.jpg","type":"image\/jpeg"}],"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\/how-to-display-month-name-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"How To Display Month Name In SQL Server ?","datePublished":"2023-12-18T05:25:00+00:00","dateModified":"2024-03-12T08:28:16+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/"},"wordCount":638,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/agenda-2296195_1920.jpg","articleSection":["T-SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/","url":"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/","name":"How To Display Month Name In SQL Server ? T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/agenda-2296195_1920.jpg","datePublished":"2023-12-18T05:25:00+00:00","dateModified":"2024-03-12T08:28:16+00:00","description":"To display the month name from a date or from the month number in SQL Server, use a query with the time functions and pick a format.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/agenda-2296195_1920.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/agenda-2296195_1920.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/t-sql\/how-to-display-month-name-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"How To Display Month Name In SQL Server ?"}]},{"@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\/6417","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=6417"}],"version-history":[{"count":28,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/6417\/revisions"}],"predecessor-version":[{"id":30618,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/6417\/revisions\/30618"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/6406"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=6417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=6417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=6417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}