UDF_获取某年某月有多少天
2024-09-04 06:32:09
UDF
--获取某年某月有多少天
--drop function fn_GetDayofMonth_1
/*
HLERP ( [dbo].[GetMonths] )
*/
go
create function dbo.fn_GetDayofMonth_1 (@Month smallint, @Year int)
returns smallint
/*获取当月的天数*/
as
begin
RETURN( Day(Dateadd(dd, -1, Dateadd(m, 1, Cast(@Year AS VARCHAR(4)) + '-'
+ Cast(@Month AS VARCHAR(2)) + '-01'))) ) end select dbo.fn_GetDayofMonth_1('','') as '',
dbo.fn_GetDayofMonth_1('','') as '',
dbo.fn_GetDayofMonth_1('','') as '',
dbo.fn_GetDayofMonth_1('','') as '',
dbo.fn_GetDayofMonth_1('','') as '',
dbo.fn_GetDayofMonth_1('','') as '',
dbo.fn_GetDayofMonth_1('','') as '',
dbo.fn_GetDayofMonth_1('','') as '',
dbo.fn_GetDayofMonth_1('','') as '',
dbo.fn_GetDayofMonth_1('','') as '',
dbo.fn_GetDayofMonth_1('','') as '',
dbo.fn_GetDayofMonth_1('','') as ''
运行结果:
--drop function fn_GetMonthDayAll
/* 参考: http://www.maomao365.com/?p=6792&sourceInfo=blog&dateInfo=20181009
制作思路:
1. 获取指定月份的第一天,
2. 并采用dateadd向后加一个月形成一个新的日期
3. 将两个日期相减,并返回之间的相差天数,作为指定月份的总天数,如下所示:
*/
Create function dbo.fn_GetDayofMonth_2(@YYYYMM varchar(20))
returns int
as
begin
declare @dayAll int
declare @monthStartDay datetime
set @monthStartDay = left(@yyyyMM,4) + '-'+ right(@YYYYMM,2) + '-01'
SELECT @dayAll = DATEDIFF(DAY, @monthStartDay, DATEADD(MONTH,1,@monthStartDay))
return @dayAll
end select dbo.fn_GetDayofMonth_2('') as '',
dbo.fn_GetDayofMonth_2('') as '',
dbo.fn_GetDayofMonth_2('') as '',
dbo.fn_GetDayofMonth_2('') as '',
dbo.fn_GetDayofMonth_2('') as '',
dbo.fn_GetDayofMonth_2('') as '',
dbo.fn_GetDayofMonth_2('') as '',
dbo.fn_GetDayofMonth_2('') as '',
dbo.fn_GetDayofMonth_2('') as '',
dbo.fn_GetDayofMonth_2('') as '',
dbo.fn_GetDayofMonth_2('') as '',
dbo.fn_GetDayofMonth_2('') as ''
运行结果:
最新文章
- 如何在Texstudio内加载语法检查词典?
- PUTTY的使用教程
- MySQL 索引详解大全
- 熟练使用git命令
- OI 回忆录
- Windows下的窗口程序
- MIT6.828 虚拟地址转化为物理地址——二级分页
- 【Java学习笔记之三十四】超详解Java多线程基础
- WEB日期控件
- Tomcat如何发布web项目
- [模板][P4782]2-SAT
- tomcat8源码分析-Connector初始化
- How To Use Amazon MWS To Download Unshipped Order Reports
- bzoj 2038 小Z的袜子 莫队算法
- Java - 尚学堂第八章常用类(将输入的string类型的值转为整数、浮点型、日期类型)
- 爬虫入门之Scrapy框架基础框架结构及腾讯爬取(十)
- 入门教程:.NET开源OpenID Connect 和OAuth解决方案IdentityServer v3 介绍 (一)
- 1066 Bash 游戏
- jason数据格式 -- 扫盲
- 统计web訪问前10的ip
热门文章
- Nginx判断客户端实现301跳转
- step over、step into、step into my code、step out、run to cursor
- [Python进阶]002.装饰器(1)
- [JavaWeb基础] 018.Struts2 Action通配符使用
- 【补充说明】Gauge框架在JS中的简单应用
- MySQL8.0 忘记密码、重置密码
- 使用 Typora 编辑器运用 Markdown 的语法编写文档
- 2019-ICCV-PDARTS-Progressive Differentiable Architecture Search Bridging the Depth Gap Between Search and Evaluation-论文阅读
- ES6-常用四种数组
- 这才是你需要的最基础的.Net基础面试题(通俗易懂,最基础的.Net)2