11 2015 档案
摘要:select day(createtime) from life_unite_product --取时间字段的天值select month(createtime) from life_unite_product --取时间字段的月值select year(createtime) from life_unite_product --取时间字段的年值 select datepart(...
阅读全文
摘要:with T as ( SELECT [idCard], (right(left([idCard],10),4)+'-'+right(left([idCard],12),2)+'-'+right(left([idCard],14),2)) 'Birthday', (case when (left(right([idCard],2),1) % 2 = 0) then '女' els...
阅读全文