SQL试题： 转化 字符串 ‘2008012015:12:34’ 为 字符串 ‘2008-01-20 15:12:34’,请教高手!

来源：百度知道 编辑：UC知道 时间：2024/06/15 09:58:28

呵呵，给你个简单的：
select convert(char(23),convert(datetime,'20080120 15:12:34',20),20)
复制到sql就可看到结果

设字符串为 2008012015:12:34 用A表示

select left(A,4)+'-'+substring(A,5,2)+'-'+substring(A,7,2)+' '+right(A,8)
或者
select left(A,4)+'-'+substring(A,5,2)+'-'+substring(A,7,2)+' '+substring(A,9,8)

CREATE FUNCTION MyCast
(@s varchar(20))
RETURNS char(19)
AS
BEGIN
DECLARE @r char(19)
select @r=convert(char(10),cast(substring(@s,1,8) as datetime),120)+' '+substring(@s,9,len(@s))
RETURN @r
END

declare @str varchar(50)
set @str='2008012015:12:34'
select left(@str,4)+'-'+substring(@str,5,2)+'-'+substring(@str,7,2)+' '+right(@str,8)