UFN_DATE_FROMFUZZYDATE
Determines if a given business process exists.
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FUZZYDATE | UDT_FUZZYDATE | IN |
Definition
Copy
CREATE function dbo.UFN_DATE_FROMFUZZYDATE
(
@FUZZYDATE dbo.UDT_FUZZYDATE
)
returns datetime
as begin
if substring(@FUZZYDATE, 7, 2) = '00'
return null;
if substring(@FUZZYDATE, 1, 4) = '0000'
return null;
if substring(@FUZZYDATE, 5, 2) = '00'
return null;
return convert(datetime, substring(@FUZZYDATE,1,4) + '-' + substring(@FUZZYDATE,5,2) + '-' + substring(@FUZZYDATE,7,2) + 'T00:00:00');
end