Re: Troubles with italian date in SQL query

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

Article #1235

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

#1235

From: Ken Chan
Date: Thu, 12 Mar 1998 00:00

13 lines
902 bytes

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

Adding to what the others said, the MDY format is required for the actual 
SQL statement in the sql property. But if for example, you specify a date 
in the SQL expression in the filter property, then the current SET DATE 
format is used.

-- 
//Ken@Borland
<Please follow-up to newsgroup; do not reply to email>

Technical Details

Message-ID: <MPG.f71ff09a4461cfb989864@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: supportinfo@borland.com (Ken Chan)
Subject: Re: Troubles with italian date in SQL query
Date: 1998/03/12
Message-ID: <MPG.f71ff09a4461cfb989864@forums.borland.com>
X-Deja-AN: 333506859
References: <3506817D.8A115C23@itelcad.it>
Organization: Borland
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message