title: How Can I use "Date" Datatype in sql server?
body: <p>Hello Friends I need your help please when I'm trying to create  column in table with data type "Date" it gives me error and I can't add it here is my code</p>
  
  <pre><code>Create table Orders (
  Order_ID INT Primary Key,
  Book_name varchar(100) ,
  isbn varchar(100) ,
  Customer_ID INT Foreign key references Customer,
  Order_date date,
  );
  </code></pre>
  
  <p>another thing it requires from me to get date of something which is before created one </p>
  
  <p>to be more clear: the query asked indicates to find date before 2 of August How can I do that </p>
  
  <p>I've try to enter data like that </p>
  
  <pre><code>Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (1, 'Design User Interface',9345678210123, 1, '02-08-2015'); 
  Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (2, 'Fire',9654693261489, 1, '05-08-2015'); 
  Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (3, 'The Odyssey',9654864332511, 2, '01-08-2015'); 
  Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (4, 'Anatomy',9654877777755, 2, '30-07-2015'); 
  Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (5, 'Surgery',9654864951753, 2, '01-07-2015'); 
  </code></pre>
  
  <p>but, it accept only first 3 insertion and last two it gives me error :/</p>