DECLARE @submit_date DATETIME;
SET @submit_date = '2007-05-19 16:10:41.403';
SELECT 'Posted in the month of '
+ DATENAME(month, @submit_date)
+ ' on a '+DATENAME(weekday, @submit_date);
GO
Posted in the month of May on a Saturday