date format

[Telma]

I have a date "2008/10/10" in sql but when I retrieve that in dataset i get it as "10/10/2008 12:00:00 AM". Can anyone explain how this happens and how to avoid it. The database has only "date" as its field type

[MrMancunian]

In the dataset, what type is the date-field? If it is datetime it will automatically add "12:00:00 AM". You could change it to Date instead.

Steven

[tlhintoq]

Why do you need to avoid it? You entered a date of 10 october 2008 and you got back a date of 10 october 2008. The date wasn't corrupted, so what's the problem?