[fdo-users] SqlServerSpatial Date Format problem

Bruno Scott bscott at geomapgis.com
Mon Apr 18 08:58:18 EDT 2011


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.

Bruno Scott



--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/SqlServerSpatial-Date-Format-problem-tp6283546p6283546.html
Sent from the FDO Users mailing list archive at Nabble.com.


More information about the fdo-users mailing list