SELECT ID, CAST(DateCreated AS DATE) AS Date,CAST(DateCreated AS TIME) AS Time
from xyz;

{
        "ID": 1,
        "Date": "2014-07-28T07:00:00.000Z",
        "Time": "13:42:12"
}