Re: BETWEEN and DATE filter

Article View: borland.public.vdbase.data.sql

Article #1368

Back to borland.public.vdbase.data.sql Previous Next

#1368

From: Ken Mayer
Date: Thu, 12 Feb 1998 00:00

20 lines
1190 bytes

Andrea Starz wrote:
> 
> Ken Mayer wrote:
> >
> > Andrea Starz wrote:
> > > N.B.: Date are in format dd/mm/yy, is important?
> >
> > Yes. Try MM/DD/YYYY to be sure ... (although MM/DD/YY should work).

> Ok modified, not work and same error.
> 

My fault -- I didn't read the SQL as thoroughly as I ought -- dates must
be strings -- change the {} to '' (single quotes ... or double if you
are using single quotes for the whole string).

-- 
Ken[1]@Borland
<Please follow-up to newsgroup; do not reply to email>

Technical Details

Message-ID: <34E33769.7850@borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<34E18B86.6F7A@mbox.vol.it> <34e5ee29.8053776@forums.borland.com> <34E31E68.C15@mbox.vol.it> <34E3247B.3FCE@borland.com> <34E328FF.28E6@mbox.vol.it>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,4441f152cccd222a
X-Google-Attributes: gidff5a1,public
From: Ken Mayer <supportinfo@borland.com>
Subject: Re: BETWEEN and DATE filter
Date: 1998/02/12
Message-ID: <34E33769.7850@borland.com>
X-Deja-AN: 324496059
Content-Transfer-Encoding: 7bit
References: <34E18B86.6F7A@mbox.vol.it> <34e5ee29.8053776@forums.borland.com> <34E31E68.C15@mbox.vol.it> <34E3247B.3FCE@borland.com> <34E328FF.28E6@mbox.vol.it>
Content-Type: text/plain; charset=us-ascii
Organization: Borland, International
Mime-Version: 1.0
Reply-To: supportinfo@borland.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message