Microsoft SQL: date formatting bug

This bug appears on Microsoft SQL Server. I used Views + Date Views for filtering content by date range taken from URL arguments and got the following error:

SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '\'.

The sample query is:

SELECT node.[title] AS [node_title], node.[nid] AS [nid], node.[language] AS [node_language], node.[created] AS [node_created], 'node' AS field_data_field_event_date_node_entity_type
FROM 
{node} node
LEFT JOIN {field_data_field_event_date} field_data_field_event_date ON node.nid = field_data_field_event_date.entity_id AND (field_data_field_event_date.entity_type = 'node' AND field_data_field_event_date.deleted = '0')
WHERE ( (( ([node].[status] = '1') AND ([node].[type] IN  ('event_on_annual_calendar')) AND (DATEPART(yyyy-mm-dd\Thh:mi:ss, CAST(field_data_field_event_date.field_event_date_value2 as smalldatetime)) >= '2011-11-25T00:00:00' AND DATEPART(yyyy-mm-dd\Thh:mi:ss, CAST(field_data_field_event_date.field_event_date_value as smalldatetime)) <= '2011-11-25T00:00:00') )) )
ORDER BY node_created DESC

MSSQL cannot take date format strings in the DATEPART function (e.g. 'yyyy-mm-dd'), only separate identifiers for year, month, day etc.
I need this functionality and work on patch now. Any help on possible solutions will be greatly appreciated.