MS SQL Server DateTime localization problems

[vertexer]

I have to use the german edition of MS SQL Server 2012 for a client project.

If I use DateTime columns like timestamps I get the following error:

 [Exception]
 SQLSTATE[22007]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Bei der Konvertierung eines nvarchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs. (SQL: insert into [users]
  ([username], [password], [updated_at], [created_at]) values (?, ?, ?, ?)) (Bindings: array (
   0 => 'username',
   1 => 'hash',
   2 =>
   DateTime::__set_state(array(
      'date' => '2013-03-21 19:11:11',
      'timezone_type' => 3,
      'timezone' => 'Europe/Berlin',
   )),
   3 =>
   DateTime::__set_state(array(
      'date' => '2013-03-21 19:11:11',
      'timezone_type' => 3,
      'timezone' => 'Europe/Berlin',
   )),
 ))

I had to change Illuminate\Database\Query\Grammars\SqlServerGrammar to get it working:

    public function getDateFormat()
    {
        return 'd.m.Y H:i:s.000';
    }
...

[vertexer]

Noob question:
How do I extend the core version of SqlServerGrammar with this variant of getDateFormat() and let laravel use my extended version without touching core files?

Right now, I copied and changed SqlServerGrammar.php and told laravel (app/config/compile.php) to include my version of this file.

But what is the correct way to do this?

[taylorotwell]

You would probably need to override the database binding in the IoC and inject a custom ConnectionFactory implementation into the database manager.

[saloo]

The issue is still there. We are having lot of issues related to date and time after migrating our app from mysql to SqlServer. There are no known solution yet for this issue.