Re: Date field in sql builder

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

Article #154

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

#154

From: Steve Koterski
Date: Thu, 04 Mar 1999 00:00

24 lines
1912 bytes

On Thu, 4 Mar 1999 10:24:06 +0100, teamb@opto-pps.com (Romain Strieff
[TeamB]) wrote:

[...]

>But only if you use the slash as separator, if you use the dot, it works. 
>It seems to think it's US dates only when it sees the "/"

You are saying that DD.MM.YYYY is acceptable in local SQL? I have to ask
you because I cannot test this. I do not have access to a non-US
BDE/Delphi/computer. What is the date format in the Windows configuration?
And how does this configuration parameter affect use of this format, if it
affects it at all? I mean, does this only work if you have the system date
format set up to use dots as date element separators?

This could be a dilemma in the local SQL online help, where I specify that
only the US format is acceptable. I am not comfortable including something
in this document without being able to empirically test it.

//////////////////////////////////////////////////////////////////////////
Steve Koterski                    "My problem lies in reconciling my gross
Technical Publications            habits with my net income."
INPRISE Corporation                             -- Errol Flynn (1909-1959)
http://www.borland.com/delphi

Technical Details

Message-ID: <36e2ca7c.5461887@forums.inprise.com>

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

References:

<7bk1bs$2i77@forums.borland.com> <36ddce30.1329713@forums.borland.com> <36e4e115.7047839@forums.inprise.com> <MPG.114868a19e128ae3989fa1@forums.inprise.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,9c0ce2ccf9b5c6e5
X-Google-Attributes: gidff5a1,public
From: skoterski@NOSPAMinprise.com (Steve Koterski)
Subject: Re: Date field in sql builder
Date: 1999/03/04
Message-ID: <36e2ca7c.5461887@forums.inprise.com>
X-Deja-AN: 451232221
Content-Transfer-Encoding: 7bit
References: <7bk1bs$2i77@forums.borland.com> <36ddce30.1329713@forums.borland.com> <36e4e115.7047839@forums.inprise.com> <MPG.114868a19e128ae3989fa1@forums.inprise.com>
Content-Type: text/plain; charset=us-ascii
Organization: INPRISE Corporation, Technical Publications
Mime-Version: 1.0
Reply-To: skoterski@NOSPAMinprise.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message