Try this :
SELECT EF.ID, EF.FileName, EF.IsOnboarding, DP.Name AS DataProviderName, DC.Name AS DataCategoryName, C.Name AS ClientName, EFS.Name AS FileStageName,
EF.FileStatus, EF.HasError, EF.UploadedOn, EF.UploadedBy, EF.dtTimeStamp AS Time_stamp
FROM ETL_Files AS EF INNER JOIN
DataProviders AS DP ON DP.ID = EF.DataProviderID INNER JOIN
DataCategories AS DC ON DC.ID = EF.DataCategoryID INNER JOIN
Clients AS C ON C.ID = 1 INNER JOIN
ETL_FileStages AS EFS ON EFS.ID = EF.FileStage WHERE CONVERT(date,dtTimeStamp,101) = '2014-10-30' ORDER BY Time_stamp DESC