Re: Data/Time literals and Access Query

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

Article #1910

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

#1910

From: Claudio Andre Heckler
Date: Fri, 16 Jan 2004 16:17

24 lines
1597 bytes

Thanks Ken, this was exactly what I was looking for!

Guess I just don't deal with Access too often.  Similar problems on
SQL Server I would tackle w/ DateSerial/TimeSerial, to dodge locale
ambiguities.

Thanks!
Claudio


"Freshy" <_REMOVE_THIS_freshy_s@hotmail.com> wrote in message
news:4007f007@newsgroups.borland.com...
> I know that this does not really answer your question, but I usually use
the
> Format function:
>
> WHERE Format(MyDateTimeField,"MM/DD/YYYY") >
> Format("01-01-2004","MM/DD/YYYY)
>
> This lets me keep things as strings which are much easier to deal with
(IMO)
>
> HTH,
> Ken

Technical Details

Message-ID: <40080139@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <4007ee3b$1@newsgroups.borland.com> <4007f007@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 07:40:37 PST
From: "Claudio Andre Heckler" <Claudio.Heckler@flexint.RemoveThis.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <4007ee3b$1@newsgroups.borland.com> <4007f007@newsgroups.borland.com>
Subject: Re: Data/Time literals and Access Query
Date: Fri, 16 Jan 2004 13:17:49 -0300
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 200.203.48.226
Message-ID: <40080139@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1074266425 200.203.48.226 (16 Jan 2004 07:20:25 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message