Framework: The format separator does not match with Carbon when using MS Sql Server

Created on 7 Jul 2016 · 7Comments · Source: laravel/framework

I am using MS SQL Server as my back end server and Larave 5.2 as the framework.

Every time I use toArray() method on eloquent collection I get this error

The format separator does not match

I am NOT overriding the getDateFormat method in any of my models.

But, I also tried to override the using the following trait

trait SqlServerDateTime {

    /**
     * Get the format for database stored dates.
     *
     * @return string
     */

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


    /**
     * Convert a DateTime to a storable string.
     * SQL Server will not accept 6 digit second fragment (PHP default: see getDateFormat Y-m-d H:i:s.u)
     * trim three digits off the value returned from the parent.
     *
     * @param  \DateTime|int  $value
     * @return string
     */

    public function fromDateTime($value)
    {
        return substr(parent::fromDateTime($value), 0, -3);
    }


}

Source

malhayek2014

Most helpful comment

I figured out how to fix this issue

This is what I have done. I created a BaseModel Class

<?php 
namespace Vendor\MyApp;

use Illuminate\Database\Eloquent\Model as EloquentModel;

class BaseModel extends EloquentModel 
{

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

    public function fromDateTime($value)
    {
        return substr(parent::fromDateTime($value), 0, -3);
    }

}

Then for each model I had I extended my BaseModel class something like this

 class User extends BaseModel 
 {
 ...
 ...
 }

I hope this helps someone else

malhayek2014 on 8 Jul 2016

❤9

All 7 comments

I figured out how to fix this issue

This is what I have done. I created a BaseModel Class

<?php 
namespace Vendor\MyApp;

use Illuminate\Database\Eloquent\Model as EloquentModel;

class BaseModel extends EloquentModel 
{

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

    public function fromDateTime($value)
    {
        return substr(parent::fromDateTime($value), 0, -3);
    }

}

Then for each model I had I extended my BaseModel class something like this

 class User extends BaseModel 
 {
 ...
 ...
 }

I hope this helps someone else

malhayek2014 on 8 Jul 2016

❤9

Thanks, man, works like a charm

a-bashtannik on 1 Aug 2016

Have you discovered the cause of this problem?

I don't want to create a base model, only to fix a bug. I'll think in a better solution.

ghost on 11 Oct 2016

This also appears to be an issue in 5.3. Creating a BaseModel class as suggested above works. Thanks!

adintegra on 3 Nov 2016

This shouldn't have been closed as it's a workaround, not a fix? I'm seeing this behaviour with MSSQL and need to maintain compatibility with other DB drivers.

matthanley on 16 Aug 2017

I was able to "fix" the problem by changing the created_at and updated_at column data. The last three digits must be 000. Exemple: 2017-11-21 17:28:54.933 must become 2017-11-21 17:28:54.000.