Re: datetime format error

Article View: borland.public.cppbuilder.database.multi-tier

Article #319

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#319

From: John Graham
Date: Sun, 13 Jan 2002 15:55

14 lines
1520 bytes

The MS SQL Server DateTime data type contains seconds and milliseconds
components.  Send it fake seconds and millisecond values.
John

chinawsb wrote:

> Hi,everyone:
>    I create a table with datetime format in SQL Server 2000,and in a
> multi-tier client,I wan't update it some field values, I find the MIDAS
> generate the SQL Command like this:
>    sp_executesql 'Update XXX Set Value=@P0 where
> AField=@P1',N'@P0=102,@P='2001-12-30 9:00 PM'
>    But in table XXX,AField value like '2001-12-30 9:00:34.230',so the
> command update nothing.Can you tell me what can I to do?

Technical Details

Message-ID: <3C41ADDA.23D4C42@salts.navy.mil>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!logbridge.uoregon.edu!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References: <3c34fbc4_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,a7cf59ab98ff92cd
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2002-01-13 07:55:49 PST
Message-ID: <3C41ADDA.23D4C42@salts.navy.mil>
Date: Sun, 13 Jan 2002 10:55:06 -0500
From: John Graham <jgraham@salts.navy.mil>
X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Re: datetime format error
References: <3c34fbc4_2@dnews>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 163.12.6.12
X-Trace: dnews 1010937300 163.12.6.12 (13 Jan 2002 07:55:00 -0800)
Lines: 15
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!logbridge.uoregon.edu!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message