Article View: borland.public.vdbase.data.sql
Article #1320Re: Troubles with italian date in SQL query
From: hirschv at mindspring dot com Ke...
Date: Wed, 11 Mar 1998 00:00
Date: Wed, 11 Mar 1998 00:00
26 lines
1324 bytes
1324 bytes
Luca Lezzerini <ua040301@itelcad.it> wrote: >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! Try SET DATE TO AMERICAN in the command window -- if this works, you can set it in the preferences menu selection. However, you may not want to make it a global change, so you may want to set the format back and forth depending on your needs ... see SET DATE in the online help. Ken --- Ken Mayer (Golden Stag Productions) http://www.mindspring.com/~hirschv
Technical Details
Message-ID:
<3506adaa.4319268@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<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: hirschv at mindspring dot com (Ken Mayer) Subject: Re: Troubles with italian date in SQL query Date: 1998/03/11 Message-ID: <3506adaa.4319268@forums.borland.com> X-Deja-AN: 333005775 References: <3506817D.8A115C23@itelcad.it> Organization: Golden Stag Productions Reply-To: hirschv@nospam.mindspring.com Newsgroups: borland.public.vdbase.data.sql