select convert(varchar(10),datepart(YYYY,a.fssj)) as years,--得到年份convert(varchar(10),datepart(mm,a.fssj)) as months,--得到月份sum(case when b.fszt in ('1','2') then a.cfs else 0 end) as fscgnumber,sum(a.cfs) as fsnumber from T_MTN_Sendrecord ainner join
转自:http://blog.itpub.net/14766526/viewspace-1156100/ select GETDATE() as '当前日期',DateName(year,GetDate()) as '年',DateName(month,GetDate()) as '月',DateName(day,GetDate()) as '日',DateName(dw,GetDate()) as '星期',DateName(week,GetDate()) as '周数',DateName(h
可以用两种方法获取 1. select GETDATE() as '当前日期', DateName(year,GetDate()) as '年', DateName(month,GetDate()) as '月', DateName(day,GetDate()) as '日', DateName(dw,GetDate()) as '星期', DateName(week,GetDate()) as '周数', DateName(hour,GetDate()) as '时', DateName(mi
两个自定义函数结合 函数一: create function convertNumToChinese ()) ) as begin ) ' set @temStr = '壹' ' set @temStr = '贰' ' set @temStr = '叁' ' set @temStr = '肆' ' set @temStr = '伍' ' set @temStr = '陆' ' set @temStr = '柒' ' set @temStr = '捌' ' set @temStr = '玖' '
也是今天sql群里有人问,看起来这个问题挺简单,但是我不知道具体该怎么实现.百度了一把,找到一个高手贡献的答案,记一下. 参考链接 sql中转换中文日期 ------ 配合相关函数 ------ create function convertNumToChinese ()) ) as begin ) ' set @temStr = '一' ' set @temStr = '二' ' set @temStr = '三' ' set @temStr = '四' ' set @temStr = '五'
1.绝对值 S:select abs(-1) value O:select abs(-1) value from dual 2.取整(大) S:select ceiling(-1.001) value O:select ceil(-1.001) value from dual 3.取整(小) S:select floor(-1.001) value O:select floor(-1.001) value from dual 4.取整(截取) S:select cast(-1.002 as in