Re: Troubles with italian date in SQL query

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

Article #1323

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

#1323

From: Bowen Moursund
Date: Wed, 11 Mar 1998 00:00

10 lines
943 bytes

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

Yes. Dates in SQL statements must be in MDY format. Convert 'em as required.
__
Bowen Moursund (TeamB)
bowenNOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm
For quick answers, check out http://forumsearch.borland.com:88

Technical Details

Message-ID: <6e6ds3$agu14@forums.borland.com>

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: "Bowen Moursund" <teamb@opto-pps.com>
Subject: Re: Troubles with italian date in SQL query
Date: 1998/03/11
Message-ID: <6e6ds3$agu14@forums.borland.com>
X-Deja-AN: 333017188
Content-Transfer-Encoding: 7bit
References: <3506817D.8A115C23@itelcad.it>
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: DataTech
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message