Not logged in - Login / Register

View History

CLR Reference: Date Of Birth

"Date Of Birth"

CLR function


SELECT [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



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