[#DDC-1032] ensure the dateformat Y-m-d gets used by the MsSQL-Server 2005

MsSQL-Server DateTime microseconds issue (DDC-1028) [DDC-1032] ensure the dateformat Y-m-d gets used by the MsSQL-Server 2005 Created: 14/Feb/11 Updated: 14/Feb/11
Status:	Open
Project:	Doctrine 2 - ORM
Component/s:	ORM
Affects Version/s:	2.0.1
Fix Version/s:	None
Security Level:	All

Type:

Sub-task

Priority:

Major

Reporter:

Martin Weise

Assignee:

Benjamin Eberlei

Resolution:

Unresolved

Votes:

Labels:

None

Environment:

php5.3.5; MsSQL-Server 2005; W2K8; Apache2; MS pdo_sqlsrv_ts_vc6 driver

Description

To ensure that the MsSQL-Server 2005 (and maybe higher) uses the format that is specified in the MsSqlPlatform class (Y-m-d)
set it via 'SET DATEFORMAT ymd' .

This should be done directly after the connection has be opened.

Comments

Comment by Martin Weise [ 14/Feb/11 ]

Issue created as wished from Juozas Kaziukenas.

Generated at Mon May 20 12:47:46 UTC 2013 using JIRA 5.2.7#850-sha1:b2af0c8dc8537b36121c6a579fabbdf79fc919e5.

[DDC-1032] ensure the dateformat Y-m-d gets used by the MsSQL-Server 2005 Created: 14/Feb/11 Updated: 14/Feb/11