I am trying to save a date in MSSQL from a C#.net application. However i always seem to have similar problems. If i use a date time varible then i get the time as well by default, and if i just use a string i have alsorts of complication when it comes to ordering unless i store it backwards. Can you suggest the most appropriate way to storing and retriving a date from a database.
Any example would be great.