datetime parameter in adoquery looses time part

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

Article #1317

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

#1317

From: Wolfgang Hardt
Date: Fri, 13 Aug 2004 12:40

20 lines
1435 bytes

Hi all,

I'm using TADOQuery with one parameter of typ datetime for updating a
timestamp field in database..
When I call ExecSQL only the date part is stored in database. The time part
is loosing .
I've got the problem with Sybase and Oracle DB's.
Using BCB6 and OLEDB ODBC
____________
q->Active=FALSE;
q->SQL->Text="insert into test1 (datum) values (:a)";
TParameter *param=q->Parameters->FindParam("a");
if(param)
    {
     param->Value = TDateTime::CurrentDateTime();
     param->DataType=ftDateTime;
    q->ExecSQL();
    }
----------------
Any ideas?

Technical Details

Message-ID: <411cb6bd@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!in.100proofnews.com!in.100proofnews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,f3f1a58d5563244b,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Wolfgang Hardt" <w.hardt@rexroth.ic.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: datetime parameter in adoquery looses time part
Date: Fri, 13 Aug 2004 14:40:00 +0200
Lines: 22
Organization: Rexroth
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 217.5.219.146
Message-ID: <411cb6bd@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1092400829 217.5.219.146 (13 Aug 2004 05:40:29 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!in.100proofnews.com!in.100proofnews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail