[Fdo-trac] [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.8.0    
  Component:  SQLServer Spatial  |     Version:  3.8.0    
   Severity:  1                  |    Keywords:           
External_id:                     |  
---------------------------------+------------------------------------------
Changes (by bscott):

  * version:  3.6.0 => 3.8.0
  * milestone:  3.6.0 => 3.8.0


Comment:

 I'm coming back on this ticket.

 The SqlServerSpatial provider format the dates as YYYY-MM-DD
 And some localized SqlServer sees that date as YYYY-DD-MM.
 It is safer to use the ISO format YYYYMMDD (without -)

 Excerpt from [http://support.microsoft.com/kb/173907/en-us / How to Set
 the Day/Month/Year Date Format in SQL Server]:

 ''A possible solution to this is to use the ISO Standard format for
 sending the datetime data to SQL Server, which is "YYYYMMDD" (no
 separators). Using the ISO format is more "international," and is
 independent of the default language''

 I'm joining a new trunk based up to date patch
 other patches can be ignored

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