This is a discussion on SQL_TIMESTAMP_STRUCT.fraction > 0 within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Does anybody know how to bind parameter of type SQL_TIMESTAMP_STRUCT to datetime columns in such a way that execution ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Does anybody know how to bind parameter of type SQL_TIMESTAMP_STRUCT to datetime columns in such a way that execution ({call XXX(?)) will not give me "Invalid precision value" if I specify SQL_TIMESTAMP_STRUCT.fraction > 0. It seems that if bind directly to SQL_TIMESTAMP_STRUCT there is no way input milliseconds. |
| |||
| Sorry for wasting your time. I found the answer. "AAO" wrote: > Does anybody know how to bind parameter of type SQL_TIMESTAMP_STRUCT to > datetime columns in such a way that execution ({call XXX(?)) will not give me > "Invalid precision value" if I specify SQL_TIMESTAMP_STRUCT.fraction > 0. It > seems that if bind directly to SQL_TIMESTAMP_STRUCT there is no way input > milliseconds. > |
| ||||
| No problem...not a waste. Thanks for posting back the solution you found. -Sue On Fri, 12 May 2006 06:15:02 -0700, AAO <AAO@discussions.microsoft.com> wrote: >Sorry for wasting your time. I found the answer. > >"AAO" wrote: > >> Does anybody know how to bind parameter of type SQL_TIMESTAMP_STRUCT to >> datetime columns in such a way that execution ({call XXX(?)) will not give me >> "Invalid precision value" if I specify SQL_TIMESTAMP_STRUCT.fraction > 0. It >> seems that if bind directly to SQL_TIMESTAMP_STRUCT there is no way input >> milliseconds. >> |