News

GitHub6y

Bad datetime format string and datetime data type for SQL Server on non US platforms

CREATE TABLE [dbo].[users] ( [id] [int] IDENTITY(1,1) NOT NULL, [name] [nvarchar](255) NOT NULL, [email] [nvarchar](255) NOT NULL, [email_verified_at] [datetime] NULL ...
GitHub6y

SQL Server datetime format is still wrong after all these years

When performing an UPDATE with a datetime field, the following exception is generated: The server returned: " An exception occurred while executing 'UPDATE MyTable ...