Article View: borland.public.cppbuilder.database.ado
Article #1914Re: Data/Time literals and Access Query
From: Matt Jacobs
Date: Fri, 16 Jan 2004 20:26
Date: Fri, 16 Jan 2004 20:26
17 lines
1303 bytes
1303 bytes
"Claudio Andre Heckler" <Claudio.Heckler@flexint.RemoveThis.com> wrote: >Hi there, this is getting me nuts ... > >How do I add date/time literals to a SQL query for Access? > >I'm trying to run something like this: > > Select * from MyTable Where > MyDateTimeField > #2004-01-01 00:00:00#; > [snip] The above query will work if you set the query ParamCheck property to false before running it.
Technical Details
Message-ID:
<q1ig0018shfm2ksrei9h7avujs6ceto45o@4ax.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mailReferences:
<4007ee3b$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,d7ad53e2c902349e X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2004-01-16 12:36:28 PST From: Matt Jacobs <noyb@noyb.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: Data/Time literals and Access Query Date: Fri, 16 Jan 2004 12:26:08 -0800 Reply-To: __noyb@noyb.com Message-ID: <q1ig0018shfm2ksrei9h7avujs6ceto45o@4ax.com> References: <4007ee3b$1@newsgroups.borland.com> X-Newsreader: Forte Agent 1.91/32.564 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 24.4.248.124 X-Trace: newsgroups.borland.com 1074284717 24.4.248.124 (16 Jan 2004 12:25:17 -0700) Lines: 18 Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail