Actually, a DateTime value is always stored the same way in the Sql database, it just a matter of the way it is presented/formatted when you see it in the Sql Manager or read it using a query...
Depends on what you want to do, but just read it into a DateTime variable and format it to string the way you want:
http://msdn.microsoft.com/en-us/library/zdtaw1bw.aspx[
^]