SQLServer สร้าง Function Text to Datetime

Create function dbo.TextToDatetime( @DateValue char(8), @TimeValue char(6))
returns datetime
as
begin
declare @DateTimeValue varchar(32)
SELECT @DateTimeValue =convert(varchar, convert(datetime, @DateValue), 111)
+ ' ' + substring(@TimeValue, 1, 2)
+ ':' + substring(@TimeValue, 3, 2)
+ ':' + substring(@TimeValue, 5, 2)

return convert(datetime, @datetimevalue,101)
end