🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: DATE FORMAT IN SQL DESIGNER

#1247
From: Eryk Bottomley
Date: Wed, 18 Mar 1998 00:00
15 lines
1117 bytes
Bowen,

>So, it's a Borland standard, eh? :-) Thanks for the correction.


It's an Industry standard ...almost everything understands MDY whereas few
products accept the correct ISO date format and some of those that do (such
as JET/Access) return corrupt result sets when the format is used. MDY is
dominant format so BI don't really have much choice about supporting it
...having said that, an ISO standard date cannot easily be confused with MDY
so I'd really like to see both formats supported by the BDE (and InterBase
come to that).

Eryk
Technical Details
Message-ID: <6enc5a$rsd2@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <3506894B.441EFE2D@bbsrc.ac.uk> <6e6ds1$agu13@forums.borland.com> <6emiiq$r227@forums.borland.com> <6en9v8$ro86@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,ee10f87f9d0c4bca
X-Google-Attributes: gidff5a1,public
From: "Eryk Bottomley" <eryk@compuserve.com>
Subject: Re: DATE FORMAT IN SQL DESIGNER
Date: 1998/03/18
Message-ID: <6enc5a$rsd2@forums.borland.com>
X-Deja-AN: 335106303
References: <3506894B.441EFE2D@bbsrc.ac.uk> <6e6ds1$agu13@forums.borland.com> <6emiiq$r227@forums.borland.com> <6en9v8$ro86@forums.borland.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: -
Newsgroups: borland.public.vdbase.data.sql