Hi folks,
I posted the following question on comp.databases.ms-sqlserver,
bu, to my surprise got no responses. So I wondered if you good
people might be able to help us out...
==================================================
Our application communicates with SQLServer 7 through ODBC. In
order to write date/time fields into the database, it uses either the dt
conversion function, or more usually the ts conversion, on a string of
the format 'yyyy-mm-dd hh:mm:ss.xxxxxx'. With almost every every
other database engine (I think Informix is the only exception), this is
accepted and converted into a date format that the back end can store.

With SQLServer 7, any inserts containing dates are dropped because the
timestamp conversion isn't working. If I take a copy of the select statement
into the query analyser, it reports an error unless I change the timestamp
string format from ts 'yyyy-mm-dd hh:mm:ss.xxxxxx' to ts 'yyyy-mm-dd
hh:mm:ss.xxx', ie from microsecond to millisecond resolution.

Version 6.5 didn't have this problem, and as I mentioned, nor does any other
database engine that our application talks to.
================================================== ===

Anyone any ideas???

Cheers,
Geoff.