fn_month_last_day (Transact_SQL)

See also:


This scalar UDF returns the last day of the month for given date.

Syntax

fn_month_last_day(@list)

Arguments

@date = DATETIME , default GETDATE(), date to find the last day of the month for;

Return type

DATETIME

Remarks

none

Permissions

Public

Dependencies

none

Examples

SELECT [Lib].[tsql].[fn_month_last_day] ('9/12/2012')

Result

9/30/2012

Other

none


Last edited Sep 14, 2012 at 7:57 PM by adudau, version 1

Comments

No comments yet.