CREATE FUNCTION DateConvertHMS(@DATEHMS VARCHAR(100))
RETURNS VARCHAR(500)
AS
BEGIN
DECLARE @DATES VARCHAR(500)
select @DATES=(case charindex('时',@DATEHMS) when '0' THEN 0 ELSE substring(@DATEHMS,1,charindex('时',@DATEHMS)-1) END) *3600 +
(case charindex('分',@DATEHMS) when '0' THEN 0 ELSE substring(@DATEHMS,charindex('时',@DATEHMS)+1,charindex('分',@DATEHMS)-charindex('时',@DATEHMS)-1)END)*60 +
(case charindex('秒',@DATEHMS) when '0' THEN 0 ELSE substring(@DATEHMS,charindex('分',@DATEHMS)+1,charindex('秒',@DATEHMS)-charindex('分',@DATEHMS)-1)END)
RETURN @DATES
END