Sql Server常用函数整理

1.获取某个月最后一天

USE [SQLQuery]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Jack Zhang>
-- Blog: http://blog.csdn.net/myxx520
-- Create date: <2011-10-27>
-- Description:	<获取某年某月的最后一天>
-- =============================================
CREATE FUNCTION [dbo].[GET_LAST_DAY]
(	
	@year varchar(4),
	@month varchar(2)
)
RETURNS datetime 

AS
	BEGIN
		DECLARE @END_TIME datetime;
		DECLARE @DATE_STR VARCHAR(10);
		SET @DATE_STR=@year+'-'+@month+'-01';
		set @END_TIME = DATEADD(DAY,-1,DATEADD(MONTH,1,CONVERT(DATETIME,CONVERT(CHAR(6),CONVERT(DATETIME,@DATE_STR,120),112)+ '01 '))) 
		RETURN @END_TIME;
	END