Post
Ask Question
shilpa mittal

shilpa mittal

  • NA
  • 9
  • 6.9k

explain query

Jul 24 2014 3:59 PM
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)