Clever Geek Handbook

Insert date into newly created table

I am using visual studio 2013 and I created this table with a date type column:

CREATE TABLE [dbo].[userTable]
(
[userId] INT NOT NULL PRIMARY KEY, 
[userName] VARCHAR(200) NOT NULL, 
[birthDate] DATE NOT NULL,
)

and when I try to insert the date manually it gives me this error message:

enter image description here

I solved the problem by changing the date format:

2015/10/03

:

15/10/03

+3


source to share


1 answer


Click on the date and time on the right side. - Set date change time - Set date change time - Change calendar setting Change the short date format accordingly.



The problem is with the replacement between month and date. enter image description here

+1


source






More articles:


All Articles