在SQL Server中定制日期/时间格式。

I am trying to write a stored procedure which selects columns from a table and adds 2 extra columns to the ResultSet. These 2 extra columns are the result of conversions on a field in the table which is a Datetime field.I am trying to write a stored procedure which s