title: Oracle date formatting
body: <p>in my c# programme i am requesting data from an oracle database and one field is the date abd time in this format - <code>12/09/2008 15:11:17</code> , is there anyway i can just return the date?</p>
  
  <p>Is there also a way of ensuring its in british format, by modifying the sql to be dd/mm/yyyy</p>
  
  <p>thanks</p>