SELECT [ARRIVED DATE]
FROM [DSPCONTENT01].[dbo].[zWMGWEEKARRIVAL]
WHERE [ARRIVED DATE] = DATEPART(weekday,CAST([ARRIVED DATE] as float))

2014-04-01
2014-04-02
2014-04-03
2014-04-04
2014-04-05
2014-04-06
2014-04-07

SELECT [ARRIVED DATE]
FROM [DSPCONTENT01].[dbo].[zWMGWEEKARRIVAL]
WHERE DATEPART(weekday,[Arrived Date]) NOT IN (1,7)