Not logged in - Login / Register


View History
R
e
q
u
e
s
t

a

d
e
m
o

CLR Reference: Date Of Birth

"Date Of Birth"

CLR function

SQLCLR:

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

Example

SQLCLR:

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

Download a Trial