Article View: borland.public.vdbase.data.sql
Article #1243Re: DATE FORMAT IN SQL DESIGNER
From: Eryk Bottomley
Date: Tue, 17 Mar 1998 00:00
Date: Tue, 17 Mar 1998 00:00
17 lines
1205 bytes
1205 bytes
Bowen, >Because the date format in SQL is MDY. VdB's SQL adheres to the standard >(actually it's a subset) to maintain scalability. Both the ANSI and ISO SQL92 standards require that dates be formatted in line with ISO-8601 which means 'yyyy-mm-dd' or an abbreviated variant. MDY is a de-facto standard, however it derives from American custom and practice, not SQL92 which the BDE claims to support. I'm not disagreeing with your observations regarding scalability, it just seemed your reply might be interpreted as meaning that MDY was required by the 'official' (ANSI/ISO) SQL standard when the reality is that a properly compliant SQL92 implementation should reject both MDY and DMY. Eryk
Technical Details
Message-ID:
<6emiiq$r227@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<3506894B.441EFE2D@bbsrc.ac.uk> <6e6ds1$agu13@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/17 Message-ID: <6emiiq$r227@forums.borland.com> X-Deja-AN: 335021500 References: <3506894B.441EFE2D@bbsrc.ac.uk> <6e6ds1$agu13@forums.borland.com> X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Organization: - Newsgroups: borland.public.vdbase.data.sql