convert函数有3个参数: CONVERT ( data_type [ ( length ) ] , expression [ , style ] ) 第一个参数返回数据类型,第二个参数是表达式,第三个是可选的定义风格的参数. 注意:不要应用CONVERT函数在被索引的日期列上. 看下面的实例: SELECT CONVERT ( VARCHAR
convert函数有3个参数:
<span>CONVERT </span><span>( </span><span>data_type [ ( length ) ] </span><span>, </span><span>expression [ , style ] </span><span>)</span>
第一个参数返回数据类型,第二个参数是表达式,第三个是可选的定义风格的参数.
注意:不要应用CONVERT函数在被索引的日期列上.
看下面的实例:
大米商城damishop
下载
damishop介绍 大米外贸商城系统 简称damishop 完全开源版，只需做一种语言一键开启全球133中语言自动翻译功能，价格实现自动汇率转换,集成微信支付宝 paypal以及国外主流支付方式，自带文章博客系统,首创支持可视化编辑。 软件架构 基于MVC+语言包模式,增加控制台，API导入产品方便对接其他系统（带json示例数据）。 使用要求
<span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>100<span>) </span><span>--Output (MON DD YYYY HH:MIAMPM) --Jul 7 2009 2:19PM </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>101<span>) </span><span>--Output (MM/DD/YYYY) --07/07/2009 </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>102<span>) </span><span>--Output (YYYY.MM.DD) --2009.07.07 </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>103<span>) </span><span>--Output (DD/MM/YYYY) --06/07/2009 </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>104<span>) </span><span>--Output (DD.MM.YYYY) --06.07.2009 </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>105<span>) </span><span>--Output (DD-MM-YYYY) --06-07-2009 </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>106<span>) </span><span>--Output (DD MON YYYY) --06 Jul 2009 </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>107<span>) </span><span>--Output (MON DD,YYYY) --Jul 06, 2009 </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>108<span>) </span><span>--Output (HH24:MI:SS) --14:24:20 </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>109<span>) </span><span>--Output (MON DD YYYY HH:MI:SS:NNN AMPM) --Jul 7 2009 2:24:35:490PM </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>110<span>) </span><span>--Output (MM-DD-YYYY) -- 07-07-2009 </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>111<span>) </span><span>--Output (YYYY/MM/DD) --2009/07/07 </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>112<span>) </span><span>--Output (YYYYMMDD) --20090707 </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>113<span>) </span><span>--Output (MON DD YYYY HH24:MI:SS:NNN) --07 Jul 2009 14:26:24:617 </span><span>SELECT </span><span>CONVERT</span><span>(</span><span>VARCHAR</span><span>(</span>30<span>),</span><span>GETDATE</span><span>(),</span>114<span>) </span><span>--Output (HH24:MI:SS:NNN) --14:26:48:953 </span>
希望这篇POST对您有用.
Author: Petter Liu http://wintersun.cnblogs.com
