Hi, I'm using Laravel 5.2. * with PHP 5.6+, everything is working as it should be when it comes to connections, use the
Make:auth to create the login with Laravel, but at the time of registration (or ok using the register by default) gives me an error:
[1/2] SQLSTATE : [Microsoft] [ODBC Driver 11 for SQL Server] [SQL Server] The conversion of nvarchar data type into datetime produced a value out of range.
[2/2] QueryException in Connection.php line 729: SQLSTATE : [Microsoft] [ODBC Driver 11 for SQL Server] [SQL Server] Conversion of the nvarchar data type in datetime produced a value outside of interval. (SQL: insert into [users] ([name], [email], [password], [updated_at], [created_at]) values (pruebabaname, [email protected], and $ f3MSrI4.mgOu3ApY5jcQIeIG85Zj1SfGVGeG / 5mGBovY5bNA1LrLe, 2017-02-23 10: 38: 54,000, 2017-02-23 10: 38: 54,000))
I understand that the given error is due to the date format between what Laravel sends and what SQL SERVER receives, but the strange thing is that when doing the command insert into from new query, I get the same error, but when I insert the data directly in the table, it works ... as I could do so that:
1- Laravel send data according to SQL
2- The field of the table adapts to receive the data well.