DateTime in SQL

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

Article #352

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

#352

From: AW
Date: Tue, 22 Aug 2006 09:17

12 lines
1174 bytes

Hello !

I want to insert a DateTime criteria as a filter in a ADODataSet.

This example works direct in MSAccess correct but not in a ADODataSet
select IDData from tbldata where DateTime = #2004/01/01 14:55:09#

How to format the DateTime ?


Thanks
Andreas

Technical Details

Message-ID: <44eacbac@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newshub.sdsu.edu!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,54e6184ef04cc148,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "AW" <weichert@trios.de>
From: "AW" <weichert@trios.de>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: DateTime in SQL
Date: Tue, 22 Aug 2006 11:17:32 +0200
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 84.129.232.123
Message-ID: <44eacbac@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1156238252 84.129.232.123 (22 Aug 2006 02:17:32 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newshub.sdsu.edu!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail