摘要: SELECT CONVERT(VARCHAR, GetDate(), 101) + ' ' + CONVERT(VARCHAR, DATEPART(hh, GetDate())) + ':' + RIGHT('0' + CONVERT(VARCHAR, DATEPART(mi, GetDate())), 2) AS Date SELECT CONVERT(CHAR(11),GETDATE(),101) + CONVERT(CHAR( 5),GETDATE(),114) Select Cast... 阅读全文
posted @ 2014-03-14 16:17 EasyPass 阅读(473) 评论(0) 推荐(0) 编辑