i solved it, have a look,
here is int:
1 - 240320141568
SUBSTRING('FeildName',CHARINDEX('-','FeildName')+3,LEN('FeildName'))
the above Query Returns 240320141568
now
SUBSTRING('FeildName',CHARINDEX('-','FeildName')+3,10)
this will return
24032014 which can be converted into date using CAST
.. :-)