Problem with MS SQL and Dateformat
Posted: 13 Feb 2008, 10:01
Iam using Mantis 1.1.1 on a Xampp installation with MS SQL Server 2005.
My SQL server is using the German Settings means dd.mm.yyyy but Mantis tries to write yyyy-mm-dd and the SQL server recognizing it not correct means today it thinks month 13 what can i do? Please do not advice to change the sqlserver globally that is not possible only the mantis tablespace can be touched.
Kind Regards
Jens Dommaschk
My SQL server is using the German Settings means dd.mm.yyyy but Mantis tries to write yyyy-mm-dd and the SQL server recognizing it not correct means today it thinks month 13 what can i do? Please do not advice to change the sqlserver globally that is not possible only the mantis tablespace can be touched.
Kind Regards
Jens Dommaschk