Article View: borland.public.vdbase.data.sql
Article #161Re: Date field in sql builder
From: Herman Viaene
Date: Fri, 05 Mar 1999 00:00
Date: Fri, 05 Mar 1999 00:00
20 lines
1391 bytes
1391 bytes
Thaks to all of you, I got ther thing working. I did some tests here: Date format in NT Control Panel and BDE Admin is dd/mm/yy date is sql builder formatted as: '12/31/1996' OK '31/12/1996' error 'Type mismatch' '12.31.1996' error 'Type mismatch' '31.12.1996' OK but is immediately reformatted by the builder to '12/31/1996' Romain Strieff [TeamB] wrote in message ... >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 "/" snip.... herman.viaene@online.be.removetherubbish
Technical Details
Message-ID:
<7bph47$7l86@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<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> <MPG.1149ffdca0b2bf75989fb3@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: "Herman Viaene" <herman.viaene@online.be> Subject: Re: Date field in sql builder Date: 1999/03/05 Message-ID: <7bph47$7l86@forums.borland.com> X-Deja-AN: 451694454 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> <MPG.1149ffdca0b2bf75989fb3@forums.inprise.com> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Organization: Another Netscape Collabra Server User Newsgroups: borland.public.vdbase.data.sql