Re: DATE FORMAT IN SQL DESIGNER

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

Article #1322

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

#1322

From: Bowen Moursund
Date: Wed, 11 Mar 1998 00:00

13 lines
1122 bytes

>Sorry to sound so basic, but why is my PC date set to DMY and yet within
>the vdbase 7 SQL designer the date is always MDY for search criteria?

Because the date format in SQL is MDY. VdB's SQL adheres to the standard
(actually it's a subset) to maintain scalability. A SQL command on a local
table will work just as well on an Oracle table. It wouldn't if local SQL
allowed DMY dates.
__
Bowen Moursund (TeamB)
bowenNOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm
For quick answers, check out http://forumsearch.borland.com:88

Technical Details

Message-ID: <6e6ds1$agu13@forums.borland.com>

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

References: <3506894B.441EFE2D@bbsrc.ac.uk>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,ee10f87f9d0c4bca
X-Google-Attributes: gidff5a1,public
From: "Bowen Moursund" <teamb@opto-pps.com>
Subject: Re: DATE FORMAT IN SQL DESIGNER
Date: 1998/03/11
Message-ID: <6e6ds1$agu13@forums.borland.com>
X-Deja-AN: 333017187
Content-Transfer-Encoding: 7bit
References: <3506894B.441EFE2D@bbsrc.ac.uk>
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: DataTech
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message