{"id":1847,"date":"2019-04-24T16:32:40","date_gmt":"2019-04-24T09:32:40","guid":{"rendered":"http:\/\/www.sqlservertutorial.net\/?page_id=1847"},"modified":"2020-04-11T20:12:22","modified_gmt":"2020-04-11T13:12:22","slug":"convert-date-to-string","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/convert-date-to-string\/","title":{"rendered":"Convert Datetime To String"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to convert datetime to string in SQL Server using the <code>CONVERT()<\/code> function.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='using-the-convert-function-to-convert-datetime-to-string'>Using the CONVERT() function to convert datetime to string <a href=\"#using-the-convert-function-to-convert-datetime-to-string\" class=\"anchor\" id=\"using-the-convert-function-to-convert-datetime-to-string\" title=\"Anchor for Using the &lt;code&gt;CONVERT()&lt;\/code&gt; function to convert datetime to string\">#<\/a><\/h2>\n\n\n\n<p>To convert a datetime to a string, you use the <code><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/sql-server-convert-function\/\">CONVERT()<\/a><\/code> function as follows:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">CONVERT(VARCHAR, datetime &#91;,style])<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In this syntax:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><code><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/sql-server-varchar\/\">VARCHAR<\/a><\/code> is the first argument that represents the string type.<\/li><li><code>datetime<\/code> is an expression that evaluates to date or datetime value that you want to convert to a string<\/li><li><code>sytle<\/code> specifies the format of the date. The value of style is a number predefined by SQL Server. The <code>style<\/code> parameter is optional.<\/li><\/ul>\n\n\n\n<p>The following table illustrates the valid style and the corresponding format of the datetime after converting to a string.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"\"><thead><tr><th>Without century (yy)<\/th><th>With century (yyyy)<\/th><th>Standard<\/th><th>Format<\/th><\/tr><\/thead><tbody><tr><td>&#8211;<\/td><td><strong>0<\/strong> or <strong class=\"\">100<\/strong><\/td><td>Default for datetime and smalldatetime<\/td><td>mon dd yyyy hh:miAM (or PM)<\/td><\/tr><tr><td><strong>1<\/strong><\/td><td><strong class=\"\">101<\/strong><\/td><td>U.S.<\/td><td>1 = mm\/dd\/yy<br>\n101 = mm\/dd\/yyyy<\/td><\/tr><tr><td><strong>2<\/strong><\/td><td><strong>102<\/strong><\/td><td>ANSI<\/td><td>2 = yy.mm.dd<br>\n102 = yyyy.mm.dd<\/td><\/tr><tr><td><strong>3<\/strong><\/td><td><strong>103<\/strong><\/td><td>British\/French<\/td><td>3 = dd\/mm\/yy<br>\n103 = dd\/mm\/yyyy<\/td><\/tr><tr><td><strong>4<\/strong><\/td><td><strong>104<\/strong><\/td><td>German<\/td><td>4 = dd.mm.yy<br>\n104 = dd.mm.yyyy<\/td><\/tr><tr><td><strong>5<\/strong><\/td><td><strong>105<\/strong><\/td><td>Italian<\/td><td>5 = dd-mm-yy<br>\n105 = dd-mm-yyyy<\/td><\/tr><tr><td><strong>6<\/strong><\/td><td><strong>106<\/strong><\/td><td>&#8211;<\/td><td>6 = dd mon yy<br>\n106 = dd mon yyyy<\/td><\/tr><tr><td><strong>7<\/strong><\/td><td><strong>107<\/strong><\/td><td>&#8211;<\/td><td>7 = Mon dd, yy<br>\n107 = Mon dd, yyyy<\/td><\/tr><tr><td><strong>8<\/strong><\/td><td><strong>108<\/strong><\/td><td>&#8211;<\/td><td>hh:mi:ss<\/td><\/tr><tr><td>&#8211;<\/td><td><strong>9<\/strong> or <strong>109<\/strong><\/td><td>Default + milliseconds<\/td><td>mon dd yyyy hh:mi:ss:mmmAM (or PM)<\/td><\/tr><tr><td><strong>10<\/strong><\/td><td><strong>110<\/strong><\/td><td>USA<\/td><td>10 = mm-dd-yy<br>\n110 = mm-dd-yyyy<\/td><\/tr><tr><td><strong>11<\/strong><\/td><td><strong>111<\/strong><\/td><td>JAPAN<\/td><td>11 = yy\/mm\/dd<br>\n111 = yyyy\/mm\/dd<\/td><\/tr><tr><td><strong>12<\/strong><\/td><td><strong>112<\/strong><\/td><td>ISO<\/td><td>12 = yymmdd<br>\n112 = yyyymmdd<\/td><\/tr><tr><td>&#8211;<\/td><td><strong>13<\/strong> or <strong>113<\/strong><\/td><td>Europe default + milliseconds<\/td><td>dd mon yyyy hh:mi:ss:mmm(24h)<\/td><\/tr><tr><td><strong>14<\/strong><\/td><td><strong class=\"\">114<\/strong><\/td><td>&#8211;<\/td><td>hh:mi:ss:mmm(24h)<\/td><\/tr><tr><td>&#8211;<\/td><td><strong>20<\/strong> or <strong>120<\/strong><\/td><td>ODBC canonical<\/td><td>yyyy-mm-dd hh:mi:ss(24h)<\/td><\/tr><tr><td>&#8211;<\/td><td><strong>21<\/strong> or <strong>121<\/strong><\/td><td>ODBC canonical (with milliseconds) default for time, date, datetime2, and datetimeoffset<\/td><td>yyyy-mm-dd hh:mi:ss.mmm(24h)<\/td><\/tr><tr><td>&#8211;<\/td><td><strong class=\"\">126<\/strong><\/td><td>ISO8601<\/td><td>yyyy-mm-ddThh:mi:ss.mmm (no spaces)<\/td><\/tr><tr><td>&#8211;<\/td><td><strong>127<\/strong><\/td><td>ISO8601 with time zone Z.<\/td><td>yyyy-mm-ddThh:mi:ss.mmmZ (no spaces)<\/td><\/tr><tr><td>&#8211;<\/td><td><strong>130<\/strong><\/td><td>Hijri<\/td><td>dd mon yyyy hh:mi:ss:mmmAM<\/td><\/tr><tr><td>&#8211;<\/td><td><strong>131<\/strong><\/td><td>Hijri<\/td><td>dd\/mm\/yyyy hh:mi:ss:mmmAM<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id='converting-a-datetime-to-a-string-examples'>Converting a datetime to a string examples <a href=\"#converting-a-datetime-to-a-string-examples\" class=\"anchor\" id=\"converting-a-datetime-to-a-string-examples\" title=\"Anchor for Converting a datetime to a string examples\">#<\/a><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id='1-convert-datetime-to-string-in-mon-dd-yyyy-hhmiam-or-pm-format-example'>1) Convert datetime to string in mon dd yyyy hh:miAM (or PM) format example <a href=\"#1-convert-datetime-to-string-in-mon-dd-yyyy-hhmiam-or-pm-format-example\" class=\"anchor\" id=\"1-convert-datetime-to-string-in-mon-dd-yyyy-hhmiam-or-pm-format-example\" title=\"Anchor for 1) Convert datetime to string in &lt;code&gt;mon dd yyyy hh:miAM (or PM)&lt;\/code&gt; format example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME = <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n\n<span class=\"hljs-keyword\">SELECT<\/span> \n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">20<\/span>),@dt,<span class=\"hljs-number\">0<\/span>) s1,\n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">20<\/span>),@dt,<span class=\"hljs-number\">100<\/span>) s2;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1                   s2\n<span class=\"hljs-comment\">-------------------- --------------------<\/span>\nDec 31 2019  2:43PM  Dec 31 2019  2:43PM\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='2-convert-datetime-to-string-in-mmddyy-and-mmddyyyy-formats-example'>2) Convert datetime to string in mm\/dd\/yy and mm\/dd\/yyyy formats example <a href=\"#2-convert-datetime-to-string-in-mmddyy-and-mmddyyyy-formats-example\" class=\"anchor\" id=\"2-convert-datetime-to-string-in-mmddyy-and-mmddyyyy-formats-example\" title=\"Anchor for 2) Convert datetime to string in &lt;code&gt;mm\/dd\/yy&lt;\/code&gt; and &lt;code&gt;mm\/dd\/yyyy&lt;\/code&gt; formats example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME = <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n<span class=\"hljs-keyword\">SELECT<\/span> \n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>),@dt,<span class=\"hljs-number\">1<\/span>) s1,\n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>),@dt,<span class=\"hljs-number\">101<\/span>) s2;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1         s2\n<span class=\"hljs-comment\">---------- ----------<\/span>\n12\/31\/19   12\/31\/2019\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='3-convert-datetime-to-string-in-mon-dd-yyyy-hhmiam-or-pm-format-example'>3) Convert datetime to string in mon dd yyyy hh:miAM (or PM) format example <a href=\"#3-convert-datetime-to-string-in-mon-dd-yyyy-hhmiam-or-pm-format-example\" class=\"anchor\" id=\"3-convert-datetime-to-string-in-mon-dd-yyyy-hhmiam-or-pm-format-example\" title=\"Anchor for 3) Convert datetime to string in &lt;code&gt;mon dd yyyy hh:miAM (or PM)&lt;\/code&gt; format example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME = <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n\n<span class=\"hljs-keyword\">SELECT<\/span> \n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>),@dt,<span class=\"hljs-number\">3<\/span>) s1,\n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>),@dt,<span class=\"hljs-number\">103<\/span>) s2;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1         s2\n<span class=\"hljs-comment\">---------- ----------<\/span>\n31\/12\/19   31\/12\/2019\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='4-convert-datetime-to-string-in-dd-mm-yy-and-dd-mm-yyyy-formats-example'>4) Convert datetime to string in dd.mm.yy and dd.mm.yyyy formats example <a href=\"#4-convert-datetime-to-string-in-dd-mm-yy-and-dd-mm-yyyy-formats-example\" class=\"anchor\" id=\"4-convert-datetime-to-string-in-dd-mm-yy-and-dd-mm-yyyy-formats-example\" title=\"Anchor for 4) Convert datetime to string in &lt;code&gt;dd.mm.yy&lt;\/code&gt; and &lt;code&gt;dd.mm.yyyy&lt;\/code&gt; formats example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME = <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n\n<span class=\"hljs-keyword\">SELECT<\/span> \n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>),@dt,<span class=\"hljs-number\">4<\/span>) s1,\n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>),@dt,<span class=\"hljs-number\">104<\/span>) s2;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1         s2\n<span class=\"hljs-comment\">---------- ----------<\/span>\n31.12.19   31.12.2019\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='5-convert-datetime-to-string-in-dd-mm-yy-dd-mm-yyyy-formats-example'>5) Convert datetime to string in dd-mm-yy dd-mm-yyyy formats example <a href=\"#5-convert-datetime-to-string-in-dd-mm-yy-dd-mm-yyyy-formats-example\" class=\"anchor\" id=\"5-convert-datetime-to-string-in-dd-mm-yy-dd-mm-yyyy-formats-example\" title=\"Anchor for 5) Convert datetime to string in &lt;code&gt;dd-mm-yy&lt;\/code&gt; &lt;code&gt;dd-mm-yyyy&lt;\/code&gt; formats example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME = <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n\n<span class=\"hljs-keyword\">SELECT<\/span> \n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>),@dt,<span class=\"hljs-number\">5<\/span>) s1,\n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>),@dt,<span class=\"hljs-number\">105<\/span>) s2;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-11\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1         s2\n<span class=\"hljs-comment\">---------- ----------<\/span>\n31-12-19   31-12-2019\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-11\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='6-convert-datetime-to-string-in-dd-mon-yy-dd-mon-yyyy-formats-example'>6) Convert datetime to string in dd mon yy dd mon yyyy formats example <a href=\"#6-convert-datetime-to-string-in-dd-mon-yy-dd-mon-yyyy-formats-example\" class=\"anchor\" id=\"6-convert-datetime-to-string-in-dd-mon-yy-dd-mon-yyyy-formats-example\" title=\"Anchor for 6) Convert datetime to string in &lt;code&gt;dd mon yy&lt;\/code&gt; &lt;code&gt;dd mon yyyy&lt;\/code&gt; formats example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-12\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME= <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n\n<span class=\"hljs-keyword\">SELECT<\/span> \n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>), @dt, <span class=\"hljs-number\">6<\/span>) s1, \n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>), @dt, <span class=\"hljs-number\">106<\/span>) s2;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-12\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-13\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1         s2\n<span class=\"hljs-comment\">---------- ----------<\/span>\n31 Dec 19  31 Dec 201\n\n(1 row affected)       \n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-13\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='7-convert-datetime-to-string-in-mon-dd-yy-mon-dd-yyyy-formats-example'>7) Convert datetime to string in Mon dd, yy Mon dd, yyyy formats example <a href=\"#7-convert-datetime-to-string-in-mon-dd-yy-mon-dd-yyyy-formats-example\" class=\"anchor\" id=\"7-convert-datetime-to-string-in-mon-dd-yy-mon-dd-yyyy-formats-example\" title=\"Anchor for 7) Convert datetime to string in &lt;code&gt;Mon dd, yy&lt;\/code&gt; &lt;code&gt;Mon dd, yyyy&lt;\/code&gt; formats example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-14\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME= <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>), @dt, <span class=\"hljs-number\">7<\/span>) s1, \n       <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>), @dt, <span class=\"hljs-number\">107<\/span>) s2;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-14\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-15\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1         s2\n<span class=\"hljs-comment\">---------- ----------<\/span>\nDec 31, 19 Dec 31, 20\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-15\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='8-convert-datetime-to-string-in-hhmiss-format-example'>8) Convert datetime to string in hh:mi:ss format example <a href=\"#8-convert-datetime-to-string-in-hhmiss-format-example\" class=\"anchor\" id=\"8-convert-datetime-to-string-in-hhmiss-format-example\" title=\"Anchor for 8) Convert datetime to string in &lt;code&gt;hh:mi:ss&lt;\/code&gt; format example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-16\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME= <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>), @dt, <span class=\"hljs-number\">108<\/span>) s1;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-16\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-17\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1\n<span class=\"hljs-comment\">----------<\/span>\n14:43:35\n\n(1 row affected) \n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-17\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='9-convert-datetime-to-string-in-mon-dd-yyyy-hhmissmmmam-or-pm-format-example'>9) Convert datetime to string in mon dd yyyy hh:mi:ss:mmmAM (or PM) format example <a href=\"#9-convert-datetime-to-string-in-mon-dd-yyyy-hhmissmmmam-or-pm-format-example\" class=\"anchor\" id=\"9-convert-datetime-to-string-in-mon-dd-yyyy-hhmissmmmam-or-pm-format-example\" title=\"Anchor for 9) Convert datetime to string in &lt;code&gt;mon dd yyyy hh:mi:ss:mmmAM (or PM)&lt;\/code&gt; format example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-18\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME= <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n<span class=\"hljs-keyword\">SELECT<\/span> \n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">30<\/span>), @dt, <span class=\"hljs-number\">109<\/span>) s1;    \n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-18\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-19\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1\n<span class=\"hljs-comment\">------------------------------<\/span>\nDec 31 2019  2:43:35:863PM\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-19\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='10-convert-datetime-to-string-in-mm-dd-yy-and-mm-dd-yyyy-format-example'>10) Convert datetime to string in mm-dd-yy and mm-dd-yyyy format example <a href=\"#10-convert-datetime-to-string-in-mm-dd-yy-and-mm-dd-yyyy-format-example\" class=\"anchor\" id=\"10-convert-datetime-to-string-in-mm-dd-yy-and-mm-dd-yyyy-format-example\" title=\"Anchor for 10) Convert datetime to string in &lt;code&gt;mm-dd-yy&lt;\/code&gt; and &lt;code&gt;mm-dd-yyyy&lt;\/code&gt; format example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-20\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME= <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>), @dt, <span class=\"hljs-number\">10<\/span>) s1, \n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>), @dt, <span class=\"hljs-number\">110<\/span>) s2;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-20\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the result set:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-21\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1         s2\n<span class=\"hljs-comment\">---------- ----------<\/span>\n12-31-19   12-31-2019\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-21\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='11-convert-datetime-to-string-in-yymmdd-and-yyyymmdd-format-example'>11) Convert datetime to string in yy\/mm\/dd and yyyy\/mm\/dd format example <a href=\"#11-convert-datetime-to-string-in-yymmdd-and-yyyymmdd-format-example\" class=\"anchor\" id=\"11-convert-datetime-to-string-in-yymmdd-and-yyyymmdd-format-example\" title=\"Anchor for 11) Convert datetime to string in &lt;code&gt;yy\/mm\/dd&lt;\/code&gt; and &lt;code&gt;yyyy\/mm\/dd&lt;\/code&gt; format example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-22\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME= <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>), @dt, <span class=\"hljs-number\">11<\/span>) s1, \n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>), @dt, <span class=\"hljs-number\">111<\/span>) s2;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-22\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the result set:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-23\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1         s2\n<span class=\"hljs-comment\">---------- ----------<\/span>\n19\/12\/31   2019\/12\/31\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-23\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='12-convert-datetime-to-string-in-yymmdd-and-yyyymmdd-format-example'>12) Convert datetime to string in yymmdd and yyyymmdd format example <a href=\"#12-convert-datetime-to-string-in-yymmdd-and-yyyymmdd-format-example\" class=\"anchor\" id=\"12-convert-datetime-to-string-in-yymmdd-and-yyyymmdd-format-example\" title=\"Anchor for 12) Convert datetime to string in &lt;code&gt;yymmdd&lt;\/code&gt; and &lt;code&gt;yyyymmdd&lt;\/code&gt; format example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-24\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME= <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>), @dt, <span class=\"hljs-number\">12<\/span>) s1, \n    <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>), @dt, <span class=\"hljs-number\">112<\/span>) s2;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-24\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the result set:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-25\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1         s2\n<span class=\"hljs-comment\">---------- ----------<\/span>\n191231     20191231\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-25\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='13-convert-datetime-to-string-in-dd-mon-yyyy-hhmissmmm24h-format-example'>13) Convert datetime to string in dd mon yyyy hh:mi:ss:mmm(24h) format example <a href=\"#13-convert-datetime-to-string-in-dd-mon-yyyy-hhmissmmm24h-format-example\" class=\"anchor\" id=\"13-convert-datetime-to-string-in-dd-mon-yyyy-hhmissmmm24h-format-example\" title=\"Anchor for 13) Convert datetime to string in &lt;code&gt;dd mon yyyy hh:mi:ss:mmm(24h)&lt;\/code&gt; format example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-26\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME= <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>), @dt, <span class=\"hljs-number\">113<\/span>) s1;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-26\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the result set:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-27\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1\n<span class=\"hljs-comment\">----------<\/span>\n31 Dec 201\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-27\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='14-convert-datetime-to-string-in-hhmissmmm24h-format-example'>14) Convert datetime to string in hh:mi:ss:mmm(24h) format example <a href=\"#14-convert-datetime-to-string-in-hhmissmmm24h-format-example\" class=\"anchor\" id=\"14-convert-datetime-to-string-in-hhmissmmm24h-format-example\" title=\"Anchor for 14) Convert datetime to string in &lt;code&gt;hh:mi:ss:mmm(24h)&lt;\/code&gt; format example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-28\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME= <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">20<\/span>), @dt, <span class=\"hljs-number\">114<\/span>) s1;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-28\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the result set:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-29\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1\n<span class=\"hljs-comment\">--------------------<\/span>\n14:43:35:863\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-29\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='15-convert-datetime-to-string-in-yyyy-mm-dd-hhmiss24h-format-example'>15) Convert datetime to string in yyyy-mm-dd hh:mi:ss(24h) format example <a href=\"#15-convert-datetime-to-string-in-yyyy-mm-dd-hhmiss24h-format-example\" class=\"anchor\" id=\"15-convert-datetime-to-string-in-yyyy-mm-dd-hhmiss24h-format-example\" title=\"Anchor for 15) Convert datetime to string in &lt;code&gt;yyyy-mm-dd hh:mi:ss(24h)&lt;\/code&gt; format example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-30\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME= <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">20<\/span>), @dt, <span class=\"hljs-number\">120<\/span>) s1;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-30\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the result set:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-31\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1\n<span class=\"hljs-comment\">--------------------<\/span>\n2019-12-31 14:43:35\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-31\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='16-convert-datetime-to-string-in-yyyy-mm-dd-hhmiss-mmm24h-format-example'>16) Convert datetime to string in yyyy-mm-dd hh:mi:ss.mmm(24h) format example <a href=\"#16-convert-datetime-to-string-in-yyyy-mm-dd-hhmiss-mmm24h-format-example\" class=\"anchor\" id=\"16-convert-datetime-to-string-in-yyyy-mm-dd-hhmiss-mmm24h-format-example\" title=\"Anchor for 16) Convert datetime to string in &lt;code&gt;yyyy-mm-dd hh:mi:ss.mmm(24h)&lt;\/code&gt; format example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-32\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME= <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">30<\/span>), @dt, <span class=\"hljs-number\">121<\/span>) s1;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-32\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the result set:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-33\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1\n<span class=\"hljs-comment\">------------------------------<\/span>\n2019-12-31 14:43:35.863\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-33\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='17-convert-datetime-to-string-in-yyyy-mm-ddthhmiss-mmm-format-example'>17) Convert datetime to string in yyyy-mm-ddThh:mi:ss.mmm format example <a href=\"#17-convert-datetime-to-string-in-yyyy-mm-ddthhmiss-mmm-format-example\" class=\"anchor\" id=\"17-convert-datetime-to-string-in-yyyy-mm-ddthhmiss-mmm-format-example\" title=\"Anchor for 17) Convert datetime to string in &lt;code&gt;yyyy-mm-ddThh:mi:ss.mmm&lt;\/code&gt; format example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-34\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME= <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">25<\/span>), @dt, <span class=\"hljs-number\">126<\/span>) s1;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-34\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the result set:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-35\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1\n<span class=\"hljs-comment\">-------------------------<\/span>\n2019-12-31T14:43:35.863\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-35\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\" id='18-convert-datetime-to-string-in-yyyy-mm-ddthhmiss-mmmz-format-example'>18) Convert datetime to string in yyyy-mm-ddThh:mi:ss.mmmZ format example <a href=\"#18-convert-datetime-to-string-in-yyyy-mm-ddthhmiss-mmmz-format-example\" class=\"anchor\" id=\"18-convert-datetime-to-string-in-yyyy-mm-ddthhmiss-mmmz-format-example\" title=\"Anchor for 18) Convert datetime to string in &lt;code&gt;yyyy-mm-ddThh:mi:ss.mmmZ&lt;\/code&gt; format example\">#<\/a><\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-36\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DECLARE<\/span> @dt DATETIME= <span class=\"hljs-string\">'2019-12-31 14:43:35.863'<\/span>;\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">CONVERT<\/span>(<span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">25<\/span>), @dt, <span class=\"hljs-number\">127<\/span>) s1;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-36\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the result set:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-37\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">s1\n<span class=\"hljs-comment\">-------------------------<\/span>\n2019-12-31T14:43:35.863\n\n(1 row affected)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-37\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In this tutorial, you have learned how to use convert a date to a string using the <code>CONVERT()<\/code> function.<\/p>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful?<\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"1847\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/convert-date-to-string\/\"\n\t\t\t\tdata-post-title=\"Convert Datetime To String\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"1847\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/convert-date-to-string\/\"\n\t\t\t\tdata-post-title=\"Convert Datetime To String\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, you will learn how to convert datetime to string in SQL Server using the CONVERT() function.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1515,"menu_order":9,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1847","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Convert Datetime to String in a Specified Format in SQL Server<\/title>\n<meta name=\"description\" content=\"In this tutorial, you will learn how to convert datetime to string in a specified format in SQL Server by using the CONVERT() function.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/convert-datetime-to-string\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Convert Datetime to String in a Specified Format in SQL Server\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, you will learn how to convert datetime to string in a specified format in SQL Server by using the CONVERT() function.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/convert-datetime-to-string\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Server Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-11T13:12:22+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-system-functions\\\/convert-datetime-to-string\\\/\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-system-functions\\\/convert-datetime-to-string\\\/\",\"name\":\"Convert Datetime to String in a Specified Format in SQL Server\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#website\"},\"datePublished\":\"2019-04-24T09:32:40+00:00\",\"dateModified\":\"2020-04-11T13:12:22+00:00\",\"description\":\"In this tutorial, you will learn how to convert datetime to string in a specified format in SQL Server by using the CONVERT() function.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-system-functions\\\/convert-datetime-to-string\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-system-functions\\\/convert-datetime-to-string\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-system-functions\\\/convert-datetime-to-string\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server System Functions\",\"item\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-system-functions\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Convert Datetime To String\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\",\"name\":\"SQL Server Tutorial\",\"description\":\"The Practical SQL Server Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Convert Datetime to String in a Specified Format in SQL Server","description":"In this tutorial, you will learn how to convert datetime to string in a specified format in SQL Server by using the CONVERT() function.","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:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/convert-datetime-to-string\/","og_locale":"en_US","og_type":"article","og_title":"Convert Datetime to String in a Specified Format in SQL Server","og_description":"In this tutorial, you will learn how to convert datetime to string in a specified format in SQL Server by using the CONVERT() function.","og_url":"https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/convert-datetime-to-string\/","og_site_name":"SQL Server Tutorial","article_modified_time":"2020-04-11T13:12:22+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/convert-datetime-to-string\/","url":"https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/convert-datetime-to-string\/","name":"Convert Datetime to String in a Specified Format in SQL Server","isPartOf":{"@id":"https:\/\/www.sqlservertutorial.net\/#website"},"datePublished":"2019-04-24T09:32:40+00:00","dateModified":"2020-04-11T13:12:22+00:00","description":"In this tutorial, you will learn how to convert datetime to string in a specified format in SQL Server by using the CONVERT() function.","breadcrumb":{"@id":"https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/convert-datetime-to-string\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/convert-datetime-to-string\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/convert-datetime-to-string\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlservertutorial.net\/"},{"@type":"ListItem","position":2,"name":"SQL Server System Functions","item":"https:\/\/www.sqlservertutorial.net\/sql-server-system-functions\/"},{"@type":"ListItem","position":3,"name":"Convert Datetime To String"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlservertutorial.net\/#website","url":"https:\/\/www.sqlservertutorial.net\/","name":"SQL Server Tutorial","description":"The Practical SQL Server Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlservertutorial.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/1847","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/comments?post=1847"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/1847\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/1515"}],"wp:attachment":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/media?parent=1847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}