加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 （https://www.lidatong.com.cn/）- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置： 首页 > 站长学院 > MsSql教程 > 正文

SqlServer之Convert 函数应用(转载)

发布时间：2020-12-12 14:33:52 所属栏目：MsSql教程 来源：网络整理
导读：SqlServer之Convert 函数应用?格式: CONVERT(data_type,expression[,style]) 说明: 此样式一般在时间类型(datetime,smalldatetime)与字符串类型(nchar,nvarchar,char,varchar) 相互转换的时候才用到. Select CONVERT(varchar(100),GETDATE(),0): 05 16 2006
SqlServer之Convert 函数应用?格式: CONVERT(data_type,expression[,style]) 说明: 此样式一般在时间类型(datetime,smalldatetime)与字符串类型(nchar,nvarchar,char,varchar) 相互转换的时候才用到. Select CONVERT(varchar(100),GETDATE(),0): 05 16 2006 10:57AM Select CONVERT(varchar(100),1): 05/16/06 Select CONVERT(varchar(100),2): 06.05.16 Select CONVERT(varchar(100),3): 16/05/06 Select CONVERT(varchar(100),4): 16.05.06 Select CONVERT(varchar(100),5): 16-05-06 Select CONVERT(varchar(100),6): 16 05 06 Select CONVERT(varchar(100),7): 05 16,06 Select CONVERT(varchar(100),8): 10:57:46 Select CONVERT(varchar(100),9): 05 16 2006 10:57:46:827AM Select CONVERT(varchar(100),10): 05-16-06 Select CONVERT(varchar(100),11): 06/05/16 Select CONVERT(varchar(100),12): 060516 Select CONVERT(varchar(100),13): 16 05 2006 10:57:46:937 Select CONVERT(varchar(100),14): 10:57:46:967 Select CONVERT(varchar(100),20): 2006-05-16 10:57:47 Select CONVERT(varchar(100),21): 2006-05-16 10:57:47.157 Select CONVERT(varchar(100),22): 05/16/06 10:57:47 AM Select CONVERT(varchar(100),23): 2006-05-16 Select CONVERT(varchar(100),24): 10:57:47 Select CONVERT(varchar(100),25): 2006-05-16 10:57:47.250 Select CONVERT(varchar(100),100): 05 16 2006 10:57AM Select CONVERT(varchar(100),101): 05/16/2006 Select CONVERT(varchar(100),102): 2006.05.16 Select CONVERT(varchar(100),103): 16/05/2006 Select CONVERT(varchar(100),104): 16.05.2006 Select CONVERT(varchar(100),105): 16-05-2006 Select CONVERT(varchar(100),106): 16 05 2006 Select CONVERT(varchar(100),107): 05 16,2006 Select CONVERT(varchar(100),108): 10:57:49 Select CONVERT(varchar(100),109): 05 16 2006 10:57:49:437AM Select CONVERT(varchar(100),110): 05-16-2006 Select CONVERT(varchar(100),111): 2006/05/16 Select CONVERT(varchar(100),112): 20060516 Select CONVERT(varchar(100),113): 16 05 2006 10:57:49:513 Select CONVERT(varchar(100),114): 10:57:49:547 Select CONVERT(varchar(100),120): 2006-05-16 10:57:49 Select CONVERT(varchar(100),121): 2006-05-16 10:57:49.700 Select CONVERT(varchar(100),126): 2006-05-16T10:57:49.827 Select CONVERT(varchar(100),130): 18 ???? ?????? 1427 10:57:49:907AM Select CONVERT(varchar(100),131): 18/04/1427 10:57:49:920AM 例子: SELECT CONVERT(varchar(30),getdate(),101) now 结果为: now --------------------------------------- |09/15/2001 style数字在转换时间时的含义如下: ------------------------------------------------------------------------------------------------------------ Style(2位表示年份)??? |?? Style(4位表示年份)??? |??? 输入输出格式??????????????????????????????????? ------------------------------------------------------------------------------------------------------------ 0??????????????????????????????? | 100??????????????????????????? |??? mon dd yyyy hh:miAM(或PM)????????????? ------------------------------------------------------------------------------------------------------------ 1??????????????????????????????? |?? 101??? 美国???????????????? |??? mm/dd/yy?????????????????????????????????????? ------------------------------------------------------------------------------------------------------------ 2??????????????????????????????? |?? 102???? ANSI??????????????? |??? yy-mm-dd??????????????????????????????????????? ------------------------------------------------------------------------------------------------------------ 3??????????????????????????????? |?? 103???? 英法???????????????? |??? dd/mm/yy?????????????????????????????????????? ------------------------------------------------------------------------------------------------------------ 4??????????????????????????????? |?? 104???? 德国???????????????? |??? dd.mm.yy??????????????????????????????????????? ------------------------------------------------------------------------------------------------------------ 5??????????????????????????????? |?? 105???? 意大利????????????? |??? dd-mm-yy??????????????????????????????????????? ------------------------------------------------------------------------------------------------------------ 6??????????????????????????????? |?? 106???????????????????????????? |??? dd mon yy??????????????????????????????????????? ------------------------------------------------------------------------------------------------------------ 7??????????????????????????????? |?? 107???????????????????????????? |??? mon dd,yy??????????????????????????????????????? ------------------------------------------------------------------------------------------------------------ 8??????????????????????????????? |?? 108???????????????????????????? |??? hh:mm:ss???????????????????????????????????????? ------------------------------------------------------------------------------------------------------------ 9??????????????????????????????? |?? 109???????????????????????????? |??? mon dd yyyy hh:mi:ss:mmmmAM(或PM) ------------------------------------------------------------------------------------------------------------ 10????????????????????????????? |?? 110???? 美国????????????????? |??? mm-dd-yy???????????????????????????????????????? ------------------------------------------------------------------------------------------------------------ 11????????????????????????????? |?? 111???? 日本????????????????? |??? yy/mm/dd??????????????????????????????????????? ------------------------------------------------------------------------------------------------------------ 12????????????????????????????? |?? 112???? ISO?????????????????? |??? yymmdd?????????????????????????????????????????? ------------------------------------------------------------------------------------------------------------ 13????????????????????????????? |?? 113????? 欧洲默认值????? |??? dd mon yyyy hh:mi:ss:mmm(24小时制)? ------------------------------------------------------------------------------------------------------------ 14????????????????????????????? |?? 114???????????????????????????? |??? hh:mi:ss:mmm(24小时制)??????????????????? ------------------------------------------------------------------------------------------------------------ 20????????????????????????????? |?? 120????? ODBC 规范????? |???? yyyy-mm-dd hh:mi:ss(24小时制)???????? ------------------------------------------------------------------------------------------------------------ 21????????????????????????????? |??? 121??????????????????????????? |???? yyyy-mm-dd hh:mi:ss:mmm(24小时制) ------------------------------------------------------------------------------------------------------------

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
    相关内容
      推荐文章
        站长推荐
        热点阅读

          【免责声明】本站内容转载自互联网，其发布内容言论不代表本站观点，如果其链接、内容的侵犯您的权益，烦请提交相关链接至邮箱bqsm@foxmail.com我们将及时予以处理。

          建议您使用1920×1080分辨率、谷歌浏览器Google Chrome、Microsoft Edge以获得本站的最佳浏览效果

          Copygight © 2008-2022 https://www.lidatong.com.cn/ All Rights Reserved. 李大同