热门标签:
获取某年某月的第一天和最后一天的Sql Server函数
浏览量:
作者:佚名
来源:互联网
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- -- =============================================
- -- Author: RickyLin
- -- Create date: 2007-11-27
- -- Description: 获取某年某月的第一天的日期
- -- =============================================
- ALTER FUNCTION fnGetFirstDayOfMonth
- (
- @Year SMALLINT
- , @Month TINYINT
- )
- RETURNS SMALLDATETIME
- AS
- BEGIN
- DECLARE @FirstDay SMALLDATETIME
- DECLARE @Str VARCHAR(10)
- SET @Str = Cast(@Year AS VARCHAR(4)) + '-' + Cast(@Month AS VARCHAR(2)) + '-1'
- SET @FirstDay = Convert(SMALLDATETIME, @Str)
- RETURN @FirstDay
- END
- GO
- -- =============================================
- -- Author: RickyLin
- -- Create date: 2007-11-27
- -- Description: 获取某年某月的最后一天的日期
- -- =============================================
- CREATE FUNCTION fnGetLastDayOfMonth
- (
- @Year SMALLINT
- , @Month TINYINT
- )
- RETURNS SMALLDATETIME
- AS
- BEGIN
- DECLARE @LastDay SMALLDATETIME
- DECLARE @Str VARCHAR(10)
- SET @Str = Cast(@Year AS VARCHAR(4)) + '-' + Cast(@Month AS VARCHAR(2)) + '-1'
- SET @LastDay = DateAdd(d, -1, DateAdd(m, 1, dbo.fnGetFirstDayOfMonth(@Year, @Month)))
- RETURN @LastDay
- END
- GO
更多...好站/酷站
本站部份资源来于互联网,只供学习之用,不得用于商业,如有侵犯版权请联系告知,本站将第一时间删除!
站长QQ:373638128 邮箱:navy1015@126.com
copyright © 2008 .Net中文社区 ASPXCS.NET™.All Rights Reserved 滇ICP备08102132号
站长QQ:373638128 邮箱:navy1015@126.com
copyright © 2008 .Net中文社区 ASPXCS.NET™.All Rights Reserved 滇ICP备08102132号

