Re: BETWEEN and DATE filter

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

Article #1285

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

#1285

From: Andrea Starz
Date: Mon, 16 Feb 1998 00:00

26 lines
1328 bytes

Ken Mayer wrote:
> 
> Andrea Starz wrote:
> > Ok it works ! But.....
> > another problem: i have a date setting to dd/mm/yy and not mm/dd/yy and
> > this is a problem to remember in query designer.
> 
> No idea of a good fix here.
> 
> > Note: if I substitute a date expression in BETWEEN with two variables of
> > data type dd/mm/yy it works correctly. Why?
> > Ex.:
> > d1={01/12/97}
> > d2={31/12/97}
> 
> I would _guess_ that some sort of automatic conversion occurs, that
> doesn't occur with a literal.
> 
> --
> Ken[1]@Borland
> <Please follow-up to newsgroup; do not reply to email>

Thanks a lot

Andrea

Technical Details

Message-ID: <34E87707.3D7@mbox.vol.it>

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> <34E33769.7850@borland.com> <34E40F33.6B82@mbox.vol.it> <34E46C19.7DC5@borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,4441f152cccd222a
X-Google-Attributes: gidff5a1,public
From: Andrea Starz <starzand@mbox.vol.it>
Subject: Re: BETWEEN and DATE filter
Date: 1998/02/16
Message-ID: <34E87707.3D7@mbox.vol.it>
X-Deja-AN: 325595755
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> <34E33769.7850@borland.com> <34E40F33.6B82@mbox.vol.it> <34E46C19.7DC5@borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: None
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message