[fdo-trac] #766: SQLServer Spatial Date Format problem

[FDO]

#766: SQLServer Spatial Date Format problem
---------------------------------+------------------------------------------
   Reporter:  bscott             |       Owner:  danstoica
       Type:  defect             |      Status:  new      
   Priority:  major              |   Milestone:  3.6.0    
  Component:  SQLServer Spatial  |     Version:  3.6.0    
   Severity:  1                  |    Keywords:           
External_id:                     |  
---------------------------------+------------------------------------------
 Hi all,
 I'm trying the SqlServer Spatial for the first time and i have some
 problems with dates

 I'm setting an FdoDateTime correctly
 but on an update or insert i'm getting this error on some dates.

 RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]La conversion d'un
 type de données varchar en type de données datetime a créé une valeur hors
 limites.

 It's a French SqlServer

 Date that works ok 2007-01-01
 Date that failed 2007-01-13
 The format here is YYYY-MM-DD

 My guess here is that MM and DD are substitued.

 Nabble thread :[http://osgeo-org.1803224.n2.nabble.com/SqlServerSpatial-
 Date-Format-problem-td6283546.html#a6528218]


 Bruno Scott

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/766>
FDO <http://fdo.osgeo.org/>
Feature Data Objects