title: select the date from ms access in dd.mm.yyyy format
body: <p>I want to select the data from the database using select command
  but the result is showing in yy.mm.dd format 
  while i want the result in dd mm yy format 
  I am using the following commad</p>
  
  <pre><code>  select  date from table1 order by date desc;
  </code></pre>
  
  <p>how can i get the date in dd mm yyyy format please help me</p>