Article View: borland.public.cppbuilder.database.ado
Article #1313Re: How do you convert MS SQL datetime field with ADODataSet in BCB 6 Pro
From: Keith Howell
Date: Wed, 11 Aug 2004 13:18
Date: Wed, 11 Aug 2004 13:18
7 lines
1199 bytes
1199 bytes
<Homer>DOH!!!!!</Homer> PLEASE IGNORE ABOVE POST...I was querying datetimes from MS SQL with 00:00:00.000 as the time stamp and TDateTime apparently does not display this time when those values are set to 0's. I finally stumbled across a datetime value that had a time other than 00:00:00.000 and it was displayed correctly.
Technical Details
Message-ID:
<e2066678.0408110518.4d4fc1f7@posting.google.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!postnews2.google.com!not-for-mailReferences:
<e2066678.0408101941.de602f5@posting.google.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,5f2b47bcf6bfbefc X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews2.google.com!not-for-mail From: keithh@flowcal.com (Keith Howell) Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: How do you convert MS SQL datetime field with ADODataSet in BCB 6 Pro Date: 11 Aug 2004 06:18:27 -0700 Organization: http://groups.google.com Lines: 7 Message-ID: <e2066678.0408110518.4d4fc1f7@posting.google.com> References: <e2066678.0408101941.de602f5@posting.google.com> NNTP-Posting-Host: 65.16.178.227 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1092230345 25781 127.0.0.1 (11 Aug 2004 13:19:05 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 11 Aug 2004 13:19:05 +0000 (UTC)