declare @a datetime declare @b varchar(100) set @b = '' set @a = '2007-2-12'if charindex('0',Convert(Varchar,@a,101))=1 begin set @b=stuff(Convert(Varchar,@a,101),1,1,'') if charindex('0',Convert(Varchar,@a,101))=3 set @b=stuff(Convert(Varchar,@a,101),3,3,'') end select @b
--Result
/*
02/27/2007
*/這樣可以不?
set @a = '2007-2-12'
Select Convert(Varchar,@a,101)
declare @b varchar(100)
set @b = ''
set @a = '2007-2-12'if charindex('0',Convert(Varchar,@a,101))=1
begin
set @b=stuff(Convert(Varchar,@a,101),1,1,'')
if charindex('0',Convert(Varchar,@a,101))=3
set @b=stuff(Convert(Varchar,@a,101),3,3,'')
end
select @b