create procedure pro_getdate(@date datetime) as select d_max=dateadd(day,-1,cast(YEAR(dateadd(month,1,@date)) as varchar(4))+'-'+cast(MONTH(dateadd(month,1,@date)) as varchar(2))+'-1') ,d_min=convert(datetime,cast(YEAR(@date) as varchar(4))+'-'+cast(MONTH(@date) as varchar(2))+'-1')
SELECT DATEADD(Day,-1,CONVERT(char(8),DATEADD(Month,1,getdate()),120)+'1')
/*
-----------------------
2010-09-01 00:00:00.000(1 個資料列受到影響)
-----------------------
2010-09-30 00:00:00.000
*/
create procedure pro_getdate(@date datetime)
as
select d_max=dateadd(day,-1,cast(YEAR(dateadd(month,1,@date)) as varchar(4))+'-'+cast(MONTH(dateadd(month,1,@date)) as varchar(2))+'-1')
,d_min=convert(datetime,cast(YEAR(@date) as varchar(4))+'-'+cast(MONTH(@date) as varchar(2))+'-1')