/**/
/*
描述:14位字符串转化成日期格式输出
DEMO:
select dbo.fn_get_datetime_from_char14('20080304110102')
*/
create function fn_get_datetime_from_char14
(
@c_date varchar ( 14 )
)
returns datetime
as
begin
declare @date varchar ( 8 ),
@time varchar ( 6 )
set @date = left ( @c_date , 8 )
set @time = right ( @c_date , 6 )
return cast ( left ( @date , 4 ) + ' - ' + substring ( @date , 5 , 2 ) + ' - ' + right ( @date , 2 ) + ' ' +
left ( @time , 2 ) + ' : ' + substring ( @time , 3 , 2 ) + ' : ' + right ( @time , 2 ) as datetime )
end
描述:14位字符串转化成日期格式输出
DEMO:
select dbo.fn_get_datetime_from_char14('20080304110102')
*/
create function fn_get_datetime_from_char14
(
@c_date varchar ( 14 )
)
returns datetime
as
begin
declare @date varchar ( 8 ),
@time varchar ( 6 )
set @date = left ( @c_date , 8 )
set @time = right ( @c_date , 6 )
return cast ( left ( @date , 4 ) + ' - ' + substring ( @date , 5 , 2 ) + ' - ' + right ( @date , 2 ) + ' ' +
left ( @time , 2 ) + ' : ' + substring ( @time , 3 , 2 ) + ' : ' + right ( @time , 2 ) as datetime )
end