Unix Technical Forum

SQL_TIMESTAMP_STRUCT.fraction > 0

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 ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 09:10 PM
=?Utf-8?B?QUFP?=
 
Posts: n/a
Default SQL_TIMESTAMP_STRUCT.fraction > 0

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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 09:11 PM
=?Utf-8?B?QUFP?=
 
Posts: n/a
Default http://support.microsoft.com/default.aspx?scid=kb;en-us;263872

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.
>

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-27-2008, 09:11 PM
Sue Hoegemeier
 
Posts: n/a
Default Re: http://support.microsoft.com/default.aspx?scid=kb;en-us;263872

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.
>>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 11:18 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com