1
Answer

explain query

Photo of shilpa mittal

shilpa mittal
10y
993
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)

Next Recommended Forum