1
Answer

explain query

shilpa mittal

shilpa mittal

10y
972
1
select SUBSTRING (convert(varchar,columnName,103),7,4)  ,
SUBSTRING (convert(varchar,columnName,100),1,6) ,
SUBSTRING (convert(varchar,columnName,100),5,2) from tablename
can any one explain me this query 
Answers (1)