{"id":107031,"date":"2022-01-25T11:00:00","date_gmt":"2022-01-25T09:00:00","guid":{"rendered":"https:\/\/examples.javacodegeeks.com\/?p=107031"},"modified":"2022-01-24T15:50:15","modified_gmt":"2022-01-24T13:50:15","slug":"sql-server-format-function","status":"publish","type":"post","link":"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/","title":{"rendered":"SQL Server FORMAT() Function"},"content":{"rendered":"<h2 class=\"wp-block-heading\" id=\"h-1-introduction\">1. Introduction<\/h2>\n<p>SQL Server provides a format function that returns a formatted value based on the specified format. It is very useful as different countries have different formats for the number, date, and currency. Here is the syntax for the <strong>Format<\/strong> function:<\/p>\n<p><span style=\"text-decoration: underline\"><em>FORMAT Syntax<\/em><\/span>\n<\/p>\n<pre class=\"wp-block-preformatted brush:sql\">FORMAT( value, format [, culture ] ) <\/pre>\n<p>It returns a formatted string and has three arguments:<\/p>\n<ul class=\"wp-block-list\">\n<li>value &#8211; required, the value to be formatted, can be either numeric or date types. <\/li>\n<li>format &#8211; required, the format pattern. e.g. &#8216;N&#8217; for number, &#8216;C&#8217; for currency, &#8216;D&#8217; for date. Click <a href=\"https:\/\/docs.microsoft.com\/en-us\/dotnet\/standard\/base-types\/formatting-types\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a> to see a list of valid format patterns.<\/li>\n<li>culture &#8211; optional, the language culture value . If not set, then default to the value of the SET LANGUAGE&nbsp;statement. Click <a href=\"http:\/\/www.sql-server-helper.com\/sql-server-2012\/format-string-function-culture.aspx\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a> to see a list of valid cultures.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\" id=\"h-2-technologies-used\">2. Technologies Used<\/h2>\n<p>The example code in this article was built and run using:<\/p>\n<ul class=\"wp-block-list\">\n<li>SQL<\/li>\n<li>SQL Server <a href=\"https:\/\/www.w3schools.com\/sql\/trysqlserver.asp?\">here<\/a><\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\" id=\"h-3-format-number\">3. Format Number<\/h2>\n<p>In this step, I will show how to format a number with the <strong>FORMAT<\/strong> function.<\/p>\n<h3 class=\"wp-block-heading\" id=\"h-3-1-format-pattern-n\">3.1 Format Pattern N<\/h3>\n<p>Open a web browser and navigate <a href=\"https:\/\/www.w3schools.com\/sql\/trysqlserver.asp?filename=trysql_func_sqlserver_format2\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>. Then, enter the SQL command:<div style=\"display:inline-block; margin: 15px 0;\"> <div id=\"adngin-JavaCodeGeeks_incontent_video-0\" style=\"display:inline-block;\"><\/div> <\/div><\/p>\n<p><span style=\"text-decoration: underline\"><em>FORMAT N<\/em><\/span>\n<\/p>\n<pre class=\"wp-block-preformatted brush:sql\">SELECT FORMAT(123456789.34, 'N');<\/pre>\n<p>Click the &#8220;<strong>RUN SQL<\/strong>&#8221; button and you should see the following output:<\/p>\n<pre class=\"wp-block-preformatted brush:plain\">123,456,789.34<\/pre>\n<p>The format pattern <strong>N <\/strong>is for number, <strong>N1 <\/strong>is for number format with 1 decimal. The following command returns the number with a one decimal point.<\/p>\n<p><span style=\"text-decoration: underline\"><em>FORMAT N1<\/em><\/span>\n<\/p>\n<pre class=\"wp-block-preformatted brush:sql\">SELECT FORMAT(123456789.37, 'N1')<\/pre>\n<p>Click the &#8220;<strong>Run SQL<\/strong>&#8221; button and you should see the following output:<\/p>\n<pre class=\"wp-block-preformatted brush:plain\">123,456,789.4<\/pre>\n<h3 class=\"wp-block-heading\" id=\"h-3-2-format-pattern-p\">3.2 Format Pattern P<\/h3>\n<p>In this step, I will format a number with percentage format with the P pattern.<\/p>\n<p>I will continue by using the online tool and enter the following SQL command:<\/p>\n<p><span style=\"text-decoration: underline\"><em>FORMAT P<\/em><\/span>\n<\/p>\n<pre class=\"wp-block-preformatted brush:sql\">SELECT FORMAT(.37, 'P');<\/pre>\n<p>Click &#8220;<strong>Run SQL<\/strong>&#8220;, you should see the following output:<\/p>\n<pre class=\"wp-block-preformatted brush:plain\">37.00%<\/pre>\n<h3 class=\"wp-block-heading\" id=\"h-3-3-format-pattern-c\">3.3 Format Pattern C<\/h3>\n<p>In this step, I will format money with the C pattern.  Enter the following command:<\/p>\n<p><span style=\"text-decoration: underline\"><em>FORMAT C<\/em><\/span>\n<\/p>\n<pre class=\"wp-block-preformatted brush:sql\">SELECT FORMAT (1234, 'C');<\/pre>\n<p>Click &#8220;<strong>Run SQL<\/strong>&#8220;, you should see the following output:<\/p>\n<pre class=\"wp-block-preformatted brush:plain\">$1,234.00<\/pre>\n<h3 class=\"wp-block-heading\" id=\"h-3-4-format-with-custom-pattern\">3.4 Format with Custom Pattern<\/h3>\n<p>In this step, I will format a number based on the customized pattern &#8211; ##-##-#####.##.<\/p>\n<p><span style=\"text-decoration: underline\"><em>FORMAT Custom Pattern<\/em><\/span>\n<\/p>\n<pre class=\"wp-block-preformatted brush:sql\">SELECT FORMAT(123456789.34, '##-##-#####.##');<\/pre>\n<p>Click &#8220;Run SQL&#8221;, you should see the following output:<\/p>\n<pre class=\"wp-block-preformatted brush:sql\">12-34-56789.34<\/pre>\n<h2 class=\"wp-block-heading\" id=\"h-4-format-date\">4. Format Date<\/h2>\n<p>In this step, I will show how to format a date with the FORMAT function.<\/p>\n<h3 class=\"wp-block-heading\" id=\"h-4-1-format-pattern-d-d\">4.1 Format Pattern d &amp; D<\/h3>\n<p>Continue with the online SQL tool, enter the following command:<\/p>\n<p><span style=\"text-decoration: underline\"><em>FORMAT D<\/em><\/span>\n<\/p>\n<pre class=\"wp-block-preformatted brush:sql\">DECLARE @d DATETIME = '1\/23\/2022';  \nSELECT FORMAT (@d, 'd', 'en-US') AS 'US English Result',  \n       FORMAT (@d, 'd', 'no') AS 'Norwegian Result',  \n       FORMAT (@d, 'd', 'zu') AS 'Zulu Result',\n       FORMAT (@d, 'D', 'zu') AS 'Zulu Result long',\n       FORMAT(@d, 'd', 'zh') AS 'Chinese Result',\n       FORMAT(@d, 'D', 'zh') AS 'Chinese Result long'<\/pre>\n<p>Click the &#8220;<strong>RUN SQL<\/strong>&#8221; button and you should see the following output.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/01\/format_date.jpg\"><img decoding=\"async\" width=\"652\" height=\"619\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/01\/format_date.jpg\" alt=\"sql format - date\" class=\"wp-image-107054\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/01\/format_date.jpg 652w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/01\/format_date-300x285.jpg 300w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/a><figcaption>Figure 1 SQL FORMAT Date<\/figcaption><\/figure>\n<\/div>\n<h3 class=\"wp-block-heading\" id=\"h-4-2-format-with-custom-pattern\">4.2 Format with Custom Pattern<\/h3>\n<p>Continue with the online SQL tool, enter the following command:<\/p>\n<p><span style=\"text-decoration: underline\"><em>FORMAT Custom Pattern<\/em><\/span>\n<\/p>\n<pre class=\"wp-block-preformatted brush:sql\">SELECT FORMAT (getdate(), 'dd\/MM\/yyyy');<\/pre>\n<p>Click &#8220;<strong>RUN SQL<\/strong>&#8220;, you should see the following output:<\/p>\n<pre class=\"wp-block-preformatted brush:plain\">23\/01\/2022<\/pre>\n<h2 class=\"wp-block-heading\" id=\"h-5-summary\">5. Summary<\/h2>\n<p>In this example, I explained the SQL <strong>FORMAT<\/strong> function and showed a few examples to format a number and date types. Click <a href=\"https:\/\/www.mssqltips.com\/sqlservertip\/2655\/format-sql-server-dates-with-format-function\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a> for more detailed examples.<\/p>\n<h2 class=\"wp-block-heading\" id=\"h-6-download-the-source-code\">6. Download the Source Code<\/h2>\n<div class=\"download\"><strong>Download<\/strong><br \/>\nYou can download the full source code of this example here: <a><strong>SQL Server FORMAT() Function<\/strong><\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>1. Introduction SQL Server provides a format function that returns a formatted value based on the specified format. It is very useful as different countries have different formats for the number, date, and currency. Here is the syntax for the Format function: FORMAT Syntax FORMAT( value, format [, culture ] ) It returns a formatted &hellip;<\/p>\n","protected":false},"author":140,"featured_media":1204,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[46668],"class_list":["post-107031","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server FORMAT() Function - Java Code Geeks<\/title>\n<meta name=\"description\" content=\"SQL Server&#039;s format function returns a formatted value based on the specified one. This is useful because there are different formats.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server FORMAT() Function - Java Code Geeks\" \/>\n<meta property=\"og:description\" content=\"SQL Server&#039;s format function returns a formatted value based on the specified one. This is useful because there are different formats.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/\" \/>\n<meta property=\"og:site_name\" content=\"Examples Java Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/javacodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-25T09:00:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Mary Zheng\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:site\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mary Zheng\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/\"},\"author\":{\"name\":\"Mary Zheng\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/8a2034fbabcb20a9396e9819261855ae\"},\"headline\":\"SQL Server FORMAT() Function\",\"datePublished\":\"2022-01-25T09:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/\"},\"wordCount\":458,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"keywords\":[\"SQL Server\"],\"articleSection\":[\"sql\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/\",\"name\":\"SQL Server FORMAT() Function - Java Code Geeks\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"datePublished\":\"2022-01-25T09:00:00+00:00\",\"description\":\"SQL Server's format function returns a formatted value based on the specified one. This is useful because there are different formats.\",\"breadcrumb\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#primaryimage\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"width\":150,\"height\":150,\"caption\":\"Bipartite Graph\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/examples.javacodegeeks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java Development\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Core Java\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"sql\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"SQL Server FORMAT() Function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"name\":\"Java Code Geeks\",\"description\":\"Java Examples and Code Snippets\",\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"alternateName\":\"JCG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/javacodegeeks\",\"https:\/\/x.com\/javacodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/8a2034fbabcb20a9396e9819261855ae\",\"name\":\"Mary Zheng\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2017\/11\/Mary-Zheng_avatar_1510732235-96x96.jpg\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2017\/11\/Mary-Zheng_avatar_1510732235-96x96.jpg\",\"caption\":\"Mary Zheng\"},\"description\":\"Mary has graduated from Mechanical Engineering department at ShangHai JiaoTong University. She also holds a Master degree in Computer Science from Webster University. During her studies she has been involved with a large number of projects ranging from programming and software engineering. She works as a senior Software Engineer in the telecommunications sector where she acts as a leader and works with others to design, implement, and monitor the software solution.\",\"url\":\"https:\/\/examples.javacodegeeks.com\/author\/mary-zheng\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server FORMAT() Function - Java Code Geeks","description":"SQL Server's format function returns a formatted value based on the specified one. This is useful because there are different formats.","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:\/\/examples.javacodegeeks.com\/sql-server-format-function\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server FORMAT() Function - Java Code Geeks","og_description":"SQL Server's format function returns a formatted value based on the specified one. This is useful because there are different formats.","og_url":"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/","og_site_name":"Examples Java Code Geeks","article_publisher":"https:\/\/www.facebook.com\/javacodegeeks","article_published_time":"2022-01-25T09:00:00+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","type":"image\/jpeg"}],"author":"Mary Zheng","twitter_card":"summary_large_image","twitter_creator":"@javacodegeeks","twitter_site":"@javacodegeeks","twitter_misc":{"Written by":"Mary Zheng","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#article","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/"},"author":{"name":"Mary Zheng","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/8a2034fbabcb20a9396e9819261855ae"},"headline":"SQL Server FORMAT() Function","datePublished":"2022-01-25T09:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/"},"wordCount":458,"commentCount":0,"publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","keywords":["SQL Server"],"articleSection":["sql"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/","url":"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/","name":"SQL Server FORMAT() Function - Java Code Geeks","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#primaryimage"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","datePublished":"2022-01-25T09:00:00+00:00","description":"SQL Server's format function returns a formatted value based on the specified one. This is useful because there are different formats.","breadcrumb":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#primaryimage","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","width":150,"height":150,"caption":"Bipartite Graph"},{"@type":"BreadcrumbList","@id":"https:\/\/examples.javacodegeeks.com\/sql-server-format-function\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/examples.javacodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Java Development","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/"},{"@type":"ListItem","position":3,"name":"Core Java","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/"},{"@type":"ListItem","position":4,"name":"sql","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/"},{"@type":"ListItem","position":5,"name":"SQL Server FORMAT() Function"}]},{"@type":"WebSite","@id":"https:\/\/examples.javacodegeeks.com\/#website","url":"https:\/\/examples.javacodegeeks.com\/","name":"Java Code Geeks","description":"Java Examples and Code Snippets","publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"alternateName":"JCG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/examples.javacodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/examples.javacodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/javacodegeeks","https:\/\/x.com\/javacodegeeks"]},{"@type":"Person","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/8a2034fbabcb20a9396e9819261855ae","name":"Mary Zheng","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2017\/11\/Mary-Zheng_avatar_1510732235-96x96.jpg","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2017\/11\/Mary-Zheng_avatar_1510732235-96x96.jpg","caption":"Mary Zheng"},"description":"Mary has graduated from Mechanical Engineering department at ShangHai JiaoTong University. She also holds a Master degree in Computer Science from Webster University. During her studies she has been involved with a large number of projects ranging from programming and software engineering. She works as a senior Software Engineer in the telecommunications sector where she acts as a leader and works with others to design, implement, and monitor the software solution.","url":"https:\/\/examples.javacodegeeks.com\/author\/mary-zheng\/"}]}},"_links":{"self":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/107031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/users\/140"}],"replies":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/comments?post=107031"}],"version-history":[{"count":0,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/107031\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media\/1204"}],"wp:attachment":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media?parent=107031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/categories?post=107031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/tags?post=107031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}