SQL Server 日期格式化输出

「爱情、让人受尽委屈。」 2021-11-17 16:58 351阅读 0赞

转自:[http://hi.baidu.com/%BC%D1%C0%D6%B1%C8%BA%A3/blog/item/fdaf6c9525adfa0f7af480ec.html][http_hi.baidu.com_BC_D1_C0_D6_B1_C8_BA_A3_blog_item_fdaf6c9525adfa0f7af480ec.html]

<table> 
 <tbody> 
  <tr> 
   <td>T-SQL Script</td> 
   <td>Output format</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 0)</td> 
   <td>03&nbsp; 6 2010&nbsp; 4:19PM</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 1)</td> 
   <td>03/06/10</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 2)</td> 
   <td>10.03.06</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 3)</td> 
   <td>06/03/10</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 4)</td> 
   <td>06.03.10</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 5)</td> 
   <td>06-03-10</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 6)</td> 
   <td>06 03 10</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 7)</td> 
   <td>03 06, 10</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 8)</td> 
   <td>16:23:28</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 9)</td> 
   <td>03&nbsp; 6 2010&nbsp; 4:23:40:110PM</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 10)</td> 
   <td>03-06-10</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 11)</td> 
   <td>10/03/06</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 12)</td> 
   <td>100306</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 13)</td> 
   <td>06 03 2010 16:24:39:763</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 14)</td> 
   <td>16:24:50:823</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 20)</td> 
   <td>2010-03-06 16:25:04</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 21)</td> 
   <td>2010-03-06 16:25:18.107</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 22)</td> 
   <td>03/06/10&nbsp; 4:25:27 PM</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 23)</td> 
   <td>2010-03-06</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 24)</td> 
   <td>16:26:48</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 25)</td> 
   <td>2010-03-06 16:26:55.810</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 100)</td> 
   <td>03&nbsp; 6 2010&nbsp; 4:27PM</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 101)</td> 
   <td>03/06/2010</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 102)</td> 
   <td>2010.03.06</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 103)</td> 
   <td>06/03/2010</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 104)</td> 
   <td>06.03.2010</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 105)</td> 
   <td>06-03-2010</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 106)</td> 
   <td>06 03 2010</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 107)</td> 
   <td>03 06, 2010</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 108)</td> 
   <td>16:28:25</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 109)</td> 
   <td>03&nbsp; 6 2010&nbsp; 4:28:35:123PM</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 110)</td> 
   <td>03-06-2010</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 111)</td> 
   <td>2010/03/06</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 112)</td> 
   <td>20100306</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 113)</td> 
   <td>06 03 2010 16:29:25:217</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 114)</td> 
   <td>16:29:32:543</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 120)</td> 
   <td>2010-03-06 16:29:44</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 121)</td> 
   <td>2010-03-06 16:29:51.030</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 126)</td> 
   <td>2010-03-06T16:29:59.327</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 130)</td> 
   <td>21 ???? ????? 1431&nbsp; 4:30:06:780PM</td> 
  </tr> 
  <tr> 
   <td>SELECT CONVERT(VARCHAR(100), GETDATE(), 131)</td> 
   <td>21/03/1431&nbsp; 4:30:21:990PM</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

update by 2014-02-13 12:44

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>select</code>&nbsp; 
      <code>left</code> 
      <code>(</code> 
      <code>REPLACE</code> 
      <code>(</code> 
      <code>REPLACE</code> 
      <code>(</code> 
      <code>REPLACE</code> 
      <code>(</code> 
      <code>CONVERT</code> 
      <code>(</code> 
      <code>VARCHAR</code> 
      <code>(100), GETDATE(), 20),&nbsp;</code> 
      <code>'-'</code> 
      <code>,&nbsp;</code> 
      <code>''</code> 
      <code>),&nbsp;</code> 
      <code>' '</code> 
      <code>,&nbsp;</code> 
      <code>''</code> 
      <code>),&nbsp;</code> 
      <code>':'</code> 
      <code>,&nbsp;</code> 
      <code>''</code> 
      <code>), 12)</code> 
     </div> 
     <div>
       &nbsp; 
     </div> 
     <div> 
      <code>--返回 '201402131244'</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

转载于:https://www.cnblogs.com/liuqiyun/p/8080136.html

[http_hi.baidu.com_BC_D1_C0_D6_B1_C8_BA_A3_blog_item_fdaf6c9525adfa0f7af480ec.html]: http://hi.baidu.com/%BC%D1%C0%D6%B1%C8%BA%A3/blog/item/fdaf6c9525adfa0f7af480ec.html