使用Laravel的pdo_sqlsrv和日期格式

I finally found a way around which seems quite clean. The trick is to force Laravel to use datetime2 instead of datetime with SQL Server.

In order to do this you need to do those changes:

In Illuminate/Database/Schema/Grammars/SqlServerGrammar.php

protected function typeDateTime(Fluent $column)
{
    return 'datetime'; // Change to datetime2
}

And

protected function typeTimestamp(Fluent $column)
{
    return 'datetime'; // Change to datetime2
}

Then in Illuminate/Database/Query/Grammars/SqlServerGrammar.php:

public function getDateFormat()
{
    return 'Y-m-d H:i:s.000'; // change to 'Y-m-d H:i:s.0000000'
}

I hope it helps someone...

I fixed it using DB::raw wit SQL's server specific syntax for datetime.

public function datetime() {

    $addDate = DB::insert("insert into TABLE (date) values (convert(date,'$date',127))");

}

I don't know exactly why it happens, but the same function with classic Laravel DB syntax return SQLSTATE[22007].

public function datetime() {

    $addDate = DB::table('TABLE')
    ->insert([
        'date'=> $date]);

   // return SQLSTATE[22007]
}