摘要:
瀑布流 来自为知笔记(Wiz) 阅读全文
摘要:
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... 阅读全文