Re: BETWEEN and DATE filter

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

Article #1283

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

#1283

From: Ken Mayer
Date: Fri, 13 Feb 1998 00:00

20 lines
1269 bytes

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>

Technical Details

Message-ID: <34E46C19.7DC5@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> <34E33769.7850@borland.com> <34E40F33.6B82@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/13
Message-ID: <34E46C19.7DC5@borland.com>
X-Deja-AN: 324780310
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>
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