fn_month_first_day (Transact_SQL)

See also:


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

Syntax

fn_month_first_day(@list)

Arguments

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

Return type

DATETIME

Remarks

none

Permissions

Public

Dependencies

none

Examples

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

Result

9/1/2012

Other

none


Last edited Sep 14, 2012 at 7:56 PM by adudau, version 5

Comments

No comments yet.