UFN_DATE_NEXTQUARTER_LASTDAY
Return
Return Type |
---|
datetime |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@TODAY | datetime | IN | |
@USELATESTTIME | bit | IN |
Definition
Copy
CREATE function dbo.UFN_DATE_NEXTQUARTER_LASTDAY(@TODAY datetime, @USELATESTTIME bit)
returns datetime
with execute as caller
as
begin
declare @DATE datetime
set @DATE = dateadd(day, -1, dateadd(month, 6, dbo.UFN_DATE_THISQUARTER_FIRSTDAY(@TODAY, 0)))
if @USELATESTTIME = 0
begin
set @DATE = dbo.UFN_DATE_GETEARLIESTTIME(@DATE)
end
else
begin
set @DATE = dbo.UFN_DATE_GETLATESTTIME(@DATE)
end
return @DATE
end;