DATETIME field (URGENTLY)

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

Article #4518

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

#4518

From: Serge Klim
Date: Thu, 13 Dec 2001 09:07

14 lines
1550 bytes

I'm using Access table in the my project and one of column is DATETIME format.
I try to select in the SQL request some fields by date and time..
 from date time .. to date time.. but it's doesn't work.  The DATETIME 
format in the field is 23.11.01 23:11:00 .
I try to do it in MS ACCESS. and it's work fine. In the MSAccess sql request
looks like: SELECT * FROM calls WHERE [FULL_DATE]=#23/11/01 23:11:00# ..
But if I run this SQL request in Builder it doesnt work:
"Query1: Field '11:00'is of an unknown type". 
If I change request on ... = #23/11/2001#   (without time and with full year
in the string) it works. 
And why I have to change the dot in the date to the "/" or "-".
Is anyone can help me? I break my head.

Best regards.

Technical Details

Message-ID: <cf772edb.0112130107.4072d961@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,4c37831654a45506,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-12-13 01:07:35 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: klim@mosbusiness.ru (Serge Klim)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: DATETIME field (URGENTLY)
Date: 13 Dec 2001 01:07:34 -0800
Organization: http://groups.google.com/
Lines: 14
Message-ID: <cf772edb.0112130107.4072d961@posting.google.com>
NNTP-Posting-Host: 195.151.196.212
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1008234455 18391 127.0.0.1 (13 Dec 2001 09:07:35 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 13 Dec 2001 09:07:35 GMT