Something like this: -

SELECT

realXML.value('(/Announcement/Headline/BroadcastDate)[1]', 'DATE') AS [Date],

realXML.value('(/Announcement/Headline/BroadcastTime)[1]', 'TIME') AS [Time],

realXML.value('(/Announcement/Full_News/Code)[1]', 'VARCHAR(8)') AS [Code]

FROM (SELECT CONVERT(XML,CAST(XMLData AS NVARCHAR(MAX)), 2)

FROM @t)a(realXML);