Please let me know error in following code

Question

CASE len(@a)                    
WHEN 6 THEN SET @hour = substring(a,1,2)                    
SET @min = substring(a,3,2)                    
SET @sec = substring(a,5,2)                    
WHEN 5 THEN SET @hour=substring(a,1,1)                    
SET @min=substring(a,2,2)                    
SET @sec=substring(a,4,2)                    
WHEN 4 THEN SET @min = substring(a,1,2)                    
SET @sec = substring(a,3,2)                    
END

Answer 1

0

You dont need a CASE. It can be re-written as

select             
@hour = substring(right('00'+@a,6),1,2),            
@min = substring(right('00'+@a,6),3,2),            
@sec = substring(right('00'+@a,6),5,2)

answered Oct 23 '09 at 09:50 AM

Madhivanan
1.1k ● 1 ● 2 ● 6

(comments are locked)

Please let me know error in following code

Follow this question

Related Questions