CLR Reference: Date Of Birth

{TOC}

"Date Of Birth"

CLR function

SQLCLR:

SELECT [dbo].[DateOfBirthDynamic][dbo].[DateOfBirth] (<@birthDate, datetime>, <@shiftDays, int>, <@shiftMonth, int>, <@shiftYears, int>)

Expected input

Data: Valid datetime value shiftDays/daysShift: acceptable day range (Default is 30) shiftMonth/monthShift: acceptable month range (Default is 0) shiftYears/yearsShift: acceptable year range (Default is 0)

Expected output

Datetime value shifted to random delta days/months/years according to input ranges

Error handling

Example

SQLCLR:

SELECT [dbo].[DateOfBirthDynamic][dbo].[DateOfBirth] (CAST('01-JAN-2009' AS DATETIME), 30, 0, 0)