[MSSQL][function][함수] 오전, 오후 --> 24시간 변환하기 (varchar ->Datetime)

 
 
drop function [dbo].[fn_convert24DataTime] 
go
Create FUNCTION [dbo].[fn_convert24DataTime] (@time varchar(200))
RETURNS datetime
AS
BEGIN
 
declare @result varchar(200)
 
declare @날짜 varchar(200) = @time
 
set @result = (SELECT 
    case when CHARINDEX('후', @날짜,1) > 0  then
        dateadd(hh, 12,  cast(replace(replace(@날짜, '오전 ', ''), '오후 ', '') as datetime) )
    else
        cast(replace(replace(@날짜, '오전 ', ''), '오후 ', '') as datetime)
    end As [24H]
)
 
return convert(datetime, @result)
 
End
go
 
 
select dbo.fn_convert24DataTime('2017-06-30 오후 9:33:25')
 
--결과  2017-06-30 21:33:00.000