34,576
社区成员
发帖
与我相关
我的任务
分享
declare @date varchar(50)
set @date='2006-5-2 上午 09:55:03'
select case substring(@date,10,2)
when '下午' then
dateadd(hh,12,convert(datetime,stuff(@date,charindex('下午',@date),3,' ')))
when '上午' then
convert(datetime,stuff(@date,charindex('上午',@date),3,' '))
end
CONVERT(varchar(20),fTime,120)
select convert(varchar(20),cast(replace(replace('2006-5-2 上午 09:55:03','上午',''),'下午','') as datetime),120)
--2006-05-02 09:55:03
--YYYY-MM-DD HH:MM:SS
declare @s varchar(100)
set @s = '2006-5-2 上午 09:55:03'
select cast(replace(replace(@s,'上午',''),'下午','') as datetime)
select replace(replace('2006-5-2 上午 09:55:03','上午',''),'下午','')
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2006-5-2 09:55:03
(所影响的行数为 1 行)
SELECT CONVERT(varchar(20),fTime,120) AS fTime
FROM tb;
select replace(replace('2006-5-2 上午 09:55:03','上午',''),'下午','')