It seems like when selecting a Datetime field through ADO, I'm getting for instance "2007-01-03 14:20:15.123" if the time part is not zero, but just
"2007-01-03" if the time part is "00.00.00.000" .
This is perfectly ok in my case (I'm just storing the date part
when INSERT:ing) - my only concern is; can I always rely upon this?

You get different formats in ADO from the same column, depending upon the data?

That seems odd to me, but if so then it is an ADO issue and has nothing to do with SQL Server (as long as your dates are actually stored as datetime types and not strings...).

Yes, in a way - depending on whether the time part (also called the fractional part?) is zero or not.

Could you recommend any good forum for ADO issues?

Maybe something on here?
http://www.dbforums.com/data-access-manipulation-batch-languages/

It seems like when selecting a Datetime field through ADO, I'm getting for instance "2007-01-03 14:20:15.123" if the time part is not zero, but just
"2007-01-03" if the time part is "00.00.00.000" .
This is perfectly ok in my case (I'm just storing the date
part when INSERT:ing) - my only concern is; can I always rely upon this?

Thanks, Blindman. I'll try that board.