• MSSQL日期代码格式

    • 1 SELECT CONVERT(varchar(100),GETDATE(),0)05920119:12AM
      2 SELECT CONVERT(varchar(100),GETDATE(),1)05/09/11
      3 SELECT CONVERT(varchar(100),GETDATE(),2)11.05.09
      4 SELECT CONVERT(varchar(100),GETDATE(),3)09/05/11
      5 SELECT CONVERT(varchar(100),GETDATE(),4)09.05.11
      6 SELECT CONVERT(varchar(100),GETDATE(),5)09-05-11
      7 SELECT CONVERT(varchar(100),GETDATE(),6)090511
      8 SELECT CONVERT(varchar(100),GETDATE(),7)0509,11
      9 SELECT CONVERT(varchar(100),GETDATE(),8)09:13:14
      10 SELECT CONVERT(varchar(100),GETDATE(),9)05920119:13:14:670AM
      11 SELECT CONVERT(varchar(100),GETDATE(),10)05-09-11
      12 SELECT CONVERT(varchar(100),GETDATE(),11)11/05/09
      13 SELECT CONVERT(varchar(100),GETDATE(),12)110509
      14 SELECT CONVERT(varchar(100),GETDATE(),13)0905201109:13:14:670
      15 SELECT CONVERT(varchar(100),GETDATE(),14)09:13:14:670
      16 SELECT CONVERT(varchar(100),GETDATE(),20)2011-05-0909:13:14
      17 SELECT CONVERT(varchar(100),GETDATE(),21)2011-05-0909:13:14.670
      18 SELECT CONVERT(varchar(100),GETDATE(),22)05/09/119:15:33 AM
      19 SELECT CONVERT(varchar(100),GETDATE(),23)2011-05-09
      20 SELECT CONVERT(varchar(100),GETDATE(),24)09:15:33
      21 SELECT CONVERT(varchar(100),GETDATE(),25)2011-05-0909:15:33.140
      22 SELECT CONVERT(varchar(100),GETDATE(),100)05920119:15AM
      23 SELECT CONVERT(varchar(100),GETDATE(),101)05/09/2011
      24 SELECT CONVERT(varchar(100),GETDATE(),102)2011.05.09
      25 SELECT CONVERT(varchar(100),GETDATE(),103)09/05/2011
      26 SELECT CONVERT(varchar(100),GETDATE(),104)09.05.2011
      27 SELECT CONVERT(varchar(100),GETDATE(),105)09-05-2011
      28 SELECT CONVERT(varchar(100),GETDATE(),106)09052011
      29 SELECT CONVERT(varchar(100),GETDATE(),107)0509,2011
      30 SELECT CONVERT(varchar(100),GETDATE(),108)09:16:38
      31 SELECT CONVERT(varchar(100),GETDATE(),109)05920119:16:38:543AM
      32 SELECT CONVERT(varchar(100),GETDATE(),110)05-09-2011
      33 SELECT CONVERT(varchar(100),GETDATE(),111)2011/05/09
      34 SELECT CONVERT(varchar(100),GETDATE(),112)20110509
      35 SELECT CONVERT(varchar(100),GETDATE(),113)0905201109:17:19:857
      36 SELECT CONVERT(varchar(100),GETDATE(),114)09:17:19:857
      37 SELECT CONVERT(varchar(100),GETDATE(),120)2011-05-0909:17:19
      38 SELECT CONVERT(varchar(100),GETDATE(),121)2011-05-0909:17:19.857
      39 SELECT CONVERT(varchar(100),GETDATE(),126)2011-05-09T09:17:19.857
      40 SELECT CONVERT(varchar(100),GETDATE(),130)6 ????? ???????14329:17:19:857AM
      41 SELECT CONVERT(varchar(100),GETDATE(),131)6/06/14329:17:19:857AM

      标签: 日期, mssql

    • 当前暂无评论 »

      • 发表评论: ( 注意:为了防止广告评论,本站链接已经启用nofollow)
      •   您的名字
      •   E-mail
      •   您的网址(选填)

Powered by Typecho)))   ICP:蜀ICP备05009250号