🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Date field in sql builder

#157
From: Romain Strieff [TeamB]
Date: Fri, 05 Mar 1999 00:00
32 lines
1868 bytes
In article <36e2ca7c.5461887@forums.inprise.com>, Steve Koterski politely 
paraphrased ...
> >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. 
---
I use only US versions as well, only SET DATE GERMAN is needed in VdB, I 
guess Delphi has something similar.

> 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?
---
Yes.

> 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.

We had a thread here a couple of weeks ago where we noticed this 
behaviour.

-- 
Romain Strieff [TeamB]
Please read this newsgroup guide below before 
posting on the private Inprise newsgroups.
http://www.inprise.com/newsgroups/guide.html
--
Technical Details
Message-ID: <MPG.1149ffdca0b2bf75989fb3@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> <36e2ca7c.5461887@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: teamb@opto-pps.com (Romain Strieff [TeamB])
Subject: Re: Date field in sql builder
Date: 1999/03/05
Message-ID: <MPG.1149ffdca0b2bf75989fb3@forums.inprise.com>
X-Deja-AN: 451584576
References: <7bk1bs$2i77@forums.borland.com> <36ddce30.1329713@forums.borland.com> <36e4e115.7047839@forums.inprise.com> <MPG.114868a19e128ae3989fa1@forums.inprise.com> <36e2ca7c.5461887@forums.inprise.com>
Organization: TeamB
Newsgroups: borland.public.vdbase.data.sql