-
- Home
- Developer Center
- Documentation CLR Data Masking Components
- Date Of Birth
CLR Reference: Date Of Birth
-
Request
a trial -
Request
a demo -
Request
a quote
CLR Data Masking Components
Open Navigation Article
-
- Home
- Developer Center
- Documentation CLR Data Masking Components
- Date Of Birth
CLR Reference: Date Of Birth
-
Request
a trial -
Request
a demo -
Request
a quote
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)
×
![Enlarged Picture]()
CLR Reference: Date Of Birth
Download Manual
