Troubles with italian date in SQL query

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

Article #1319

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

#1319

From: Luca Lezzerini
Date: Wed, 11 Mar 1998 00:00

23 lines
1108 bytes

I've written an sql query with a WHERE clause on a date field.

It has been working in a very strange way since i wrote it!

After a lot of work I've found the problem:

WHERE considers the date "04/03/1998" in american format (April 3rd,
1998) instead of italian format (March 4th, 1998).

I have set date to italian (also french because I prefer the slash '/'
in my dates) but it doesn't work!

I have also edited the BDE administrator in control panel. It says date
is type 1 (DMY)!

Is there anyone who could help me?

    Thanks

    Luca Lezzerini

    mailto:lezzerin@itelcad.it

Technical Details

Message-ID: <3506817D.8A115C23@itelcad.it>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,62da82abdafdda15,start
X-Google-Attributes: gidff5a1,public
From: Luca Lezzerini <ua040301@itelcad.it>
Subject: Troubles with italian date in SQL query
Date: 1998/03/11
Message-ID: <3506817D.8A115C23@itelcad.it>
X-Deja-AN: 332966577
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql