How Can I use Date Datatype in sql server

Question

When I'm trying to create column in table with data type "Date" it is giving me error 

Create table Sales (
Order_ID INT Primary Key,
Product_name varchar(100) ,
isbn varchar(100) ,
Customer_ID INT Foreign key references Customer,
Order_date date,
);

I need to get date of something which is before created one

The query indicates to find the date before 2nd August

The code I have used is:

Insert Into Orders(Order_ID, Product_name, isbn, Customer_ID, Order_date) values (1, 'Design User Interface',9345678210123, 1, '02-08-2015'); 
Insert Into Orders(Order_ID, Product_name, isbn, Customer_ID, Order_date) values (2, 'Fire',9654693261489, 1, '05-08-2015'); 
Insert Into Orders(Order_ID, Product_name, isbn, Customer_ID, Order_date) values (3, 'The Odyssey',9654864332511, 2, '01-08-2015'); 
Insert Into Orders(Order_ID, Product_name, isbn, Customer_ID, Order_date) values (4, 'Anatomy',9654877777755, 2, '30-07-2015'); 
Insert Into Orders(Order_ID, Product_name, isbn, Customer_ID, Order_date) values (5, 'Surgery',9654864951753, 2, '01-07-2015'); 

it is accepting only the first 3 data insertion and last two it is reporting error

Answer 1

There's problem in all of them and not just the last two.

The error is due to the DATE FORMAT
Your system is taking a different date format while your data has a different one.

Your dates are as MM-DD-YYYY which depends on the culture of your system,

While using dates, it is better to use culture independent formats like the universal format:

2020-10-05 is 5th of October 2020
 

Using YYYY-MM-DD format might actually work out for your query.