Re: Troubles with italian date in SQL query

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

Article #1234

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

#1234

From: Jose Luis Perez Diez
Date: Thu, 12 Mar 1998 00:00

13 lines
921 bytes

In article <3506817D.8A115C23@itelcad.it>, Luca Lezzerini wrote:
> WHERE considers the date "04/03/1998" in american format (April 3rd,
> 1998) instead of italian format (March 4th, 1998).
You should use a Variable that way it is independent of the date format.

Fecha = {04/03/1998}
select ... where ... = :Fecha

-- 

Using Virtual Access
http://www.vamail.com

Technical Details

Message-ID: <VA.00000079.00e88c28@default>

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

References: <3506817D.8A115C23@itelcad.it>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,62da82abdafdda15
X-Google-Attributes: gidff5a1,public
From: Jose Luis Perez Diez <NOMAIL@Jluis.es>
Subject: Re: Troubles with italian date in SQL query
Date: 1998/03/12
Message-ID: <VA.00000079.00e88c28@default>
X-Deja-AN: 333303513
Content-Transfer-Encoding: 8bit
References: <3506817D.8A115C23@itelcad.it>
Content-Type: text/plain; charset=iso-8859-1
Organization: My Company
Mime-Version: 1.0
Reply-To: NOMAIL@Jluis.es
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message