SQL获取某个时间字符串里的月和日,获取某天是周几
select datename(weekday,'2016-11-4') as '周'
select convert(varchar,datepart(month,'2016-11-4')) as '月'
select convert(varchar,datepart(day,'2016-11-4')) as '日'
select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')