From: esquel@sommarskog.se   
      
   Tony Johansson (johansson.andersson@telia.com) writes:   
   > In this method GetBokningar I fetch all rows and return a DataSet but I   
   > hope I can remove the time part in some way. Now I get for example   
   > format 2013-03-12 00:00:00 for columns BokningFromDate and BokningToDate   
   > because these are DateTime column in the database. I could use  a   
   > DataReader and convert to string but I hope I can fix it within sql in   
   > some way.   
      
   Presentation issues are best done in the UI, but you could use the data   
   type date throughout in the database. Or you could do   
      
   convert(date, BookingFromDate)   
      
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)