title: How to insert date and Query date in SQLite table
body: <p>I am not familiar with SQLite on handling date.</p>
  
  <p>The problem:</p>
  
  <ol>
  <li><p>Can I insert date this way or insert any date using DateTime to create.</p>
  
  <p>Order_Date = DateTime.Today     </p></li>
  </ol>
  
  <p>How to :</p>
  
  <p>a) How to use a select or query a recordset base or Order_Date ?</p>
  
  <p>b) How to select or query a recordset base on Date Range ? from this date to this date.</p>
  
  <p>Thanks</p>
  
  <pre>
  
        Class Order
        {
       [PrimaryKey, AutoIncrement]
          public int SId { get; set; }
          public int CustId { get; set; }     
          public string No { get; set; }        
          public string Customer { get; set; }
          public DateTime Order_Date { get; set; }
  
        }
  
  
  
     using (var db = new SQLite.SQLiteConnection(DBPath))
       {
          var newOrder = new Order()
          {
             CustId = g_intCustId,
             Customer = txtBlkCustomer.Text.Trim(),
             Order_Date = DateTime.Today   
  
          };
  
     db.Insert(newOrder);
  
  
  ----- Update : <br/>
  
  1) I wanted to know what is the proper way to insert date into a field of dateTime DataType in table as Above? using Date from DateTime.Today, DateTime.Now 
  
  2) what fields need to add in SQLite table when enter Date with 
  
  a) normal Date format ( dd/mm/yyyy)
  
  b) format like :  Date with  HHMMSS
  
  3) How to query or select Date for (2a) and (2b)?
  
  
  Thanks
  
  
  
  
  
  </pre>