SQL datetime format

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

Article #3195

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

#3195

From: alex
Date: Wed, 04 Dec 2002 12:33

11 lines
1158 bytes

Hi ,

  What is the date time format  in SQL to limit  the query in some time
range
 for example :

   select column from table where time between "2/11/2002" and " 2/22/2002"

(The above syntax get  an syntax error exception  in ADO Query )

Alex

Technical Details

Message-ID: <3dedf62a@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,13893c5bae619670,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-12-04 04:39:02 PST
Reply-To: "alex" <alex@cybergraphy.com>
From: "alex" <alex@cybergraphy.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: SQL datetime format
Date: Wed, 4 Dec 2002 20:33:16 +0800
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
NNTP-Posting-Host: 61.228.59.15
Message-ID: <3dedf62a@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039005226 61.228.59.15 (4 Dec 2002 04:33:46 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail