Re: Losing milliseconds?

Article View: borland.public.cppbuilder.database.ado

Article #2651

Back to borland.public.cppbuilder.database.ado Previous Next

#2651

From: Bill Rampey
Date: Mon, 05 May 2003 21:46

21 lines
1850 bytes

Hi All,

I'm having a similar problem.  I have a datetime field in a SQL Server 2000
table.  The field has a default value of getdate() and has millisecond
values when records are added to the table.

Now for the fun part.  I have a TADOStoredProc that returns a result set
with this field. The fields are generated automatically at run-time and the
field type for this field is ftDateTime.  (This seems right to me?) However,
I'm not getting the milliseconds.  They appear to be simply discarded when
getting the value of the field.

Can anyone help?

Thanks,
Bill

> I'm using a TADOQuery component with a simple "Select * from myTable" as
> a datasource. When adding DateTime values into the database (SQL Server
> 2000), the millisecond information gets lost somewhere in between.
> As anybody else experienced this? Am I missing something?

Technical Details

Message-ID: <3eb6dbce$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!216.166.71.118.MISMATCH!small1.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3e92a296@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,395eeb86a511a1da
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-05-05 14:55:20 PST
From: "Bill Rampey" <brampey@flsg.follett.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3e92a296@newsgroups.borland.com>
Subject: Re: Losing milliseconds?
Date: Mon, 5 May 2003 16:46:53 -0500
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 12.47.12.131
Message-ID: <3eb6dbce$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1052171214 12.47.12.131 (5 May 2003 14:46:54 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!216.166.71.118.MISMATCH!small1.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message