Formatting a DATETIME field from MSSQL

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

Article #1167

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

#1167

From: Brad Arant
Date: Wed, 13 Oct 2004 21:38

8 lines
929 bytes

Hello Gang,

When I read a DATETIME field from MSSQL through TADOQuery I get garbage. 
What is the correct way to read a DATETIME field from the database.

Thanks,

Brad Arant

Technical Details

Message-ID: <ckk77p0n19@news1.newsguy.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!pln-w!spln!dex!extra.newsguy.com!newsp.newsguy.com!news1

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,cd6faf4072ac8b0d,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!pln-w!spln!dex!extra.newsguy.com!newsp.newsguy.com!news1
From: "Brad Arant" <barant@barant.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Formatting a DATETIME field from MSSQL
Date: Wed, 13 Oct 2004 14:38:06 -0700
Organization: http://newsguy.com
Lines: 10
Message-ID: <ckk77p0n19@news1.newsguy.com>
NNTP-Posting-Host: p-101.newsdawg.com
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original