SELECT
ID, mydate
FROM ( SELECT ID, CAST ( SUBSTRING (duration, CHARINDEX ( ' - ' , duration) + 1 , 10 )
AS datetime ) AS mydate
FROM yunwei
WHERE duration IS NOT NULL ) DERIVEDTBL
FROM ( SELECT ID, CAST ( SUBSTRING (duration, CHARINDEX ( ' - ' , duration) + 1 , 10 )
AS datetime ) AS mydate
FROM yunwei
WHERE duration IS NOT NULL ) DERIVEDTBL