title: What is Date? a string? or Double?
body: <p>Okay, That might be asked somewhere, but I am unable to find it over google or SO,</p>
  
  <p>My query was</p>
  
  <pre><code>INSERT INTO Tracking (OrderNum, PickupDate, ...) VALUES (95370,10/01/2013, .....)
  </code></pre>
  
  <p>plate form was a php script updating MS-Access db..and target column <code>pickupDate</code> was of Date/Time data type in access db..</p>
  
  <p>when I ran this query, the information inserted in DB <strong>wasn't</strong> <code>10/01/2013</code>, rather its was long digit like 34444444299384 (something like that, didnt noted that exactly)..</p>
  
  <p>but when I use the following query</p>
  
  <pre><code>INSERT INTO Tracking (OrderNum, PickupDate, ...) VALUES (95370,'10/01/2013', .....)
  </code></pre>
  
  <p>So for what I know is, <strong>anything between the qoutes is a STRING</strong></p>
  
  <ul>
  <li>so, is the Date a string??</li>
  <li>why results are different for 10/01/2013 and <code>"10/01/2013"</code>?</li>
  </ul>
  
  <p>Can somebody please explain it to me??</p>
  
  <p>thanks for your guideline..</p>