Article View: borland.public.vdbase.data.sql
Article #348Re: Any ideas how to make this work?
From: mike
Date: Wed, 21 Oct 1998 00:00
Date: Wed, 21 Oct 1998 00:00
20 lines
1608 bytes
1608 bytes
Steve Koterski wrote: > You can perform arithmetic operations within SQL statements, including > division. To the SQL parser, without the quotation marks the date literal > 10/20/1998 looks like 10 divided by 20 divided by 1,998 -- a value that > would be incompatible with a dBASE DATE column. But by enclosing the date > literal in quotations marks, you indicate to the SQL parser that this is > actually a date literal and not a calculation. > > ////////////////////////////////////////////////////////////////////////// > Steve Koterski "What is success in this world? I would say > Technical Publications it consists of four simple things: to live > INPRISE Corporation a lot, to love a lot, to laugh a lot, and > http://www.inprise.com/delphi from it all, to learn a lot." > -- Richard J. Needham Thanks for the info. That makes it a bit clearer! Mike
Technical Details
Message-ID:
<362DFE7C.7F70E102@notgiven.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<362CB185.25FCA8EF@notgiven.com> <3630d1d7.9783294@forums.inprise.com> <362CE18D.C2334D6A@notgiven.com> <3630202b.29838518@forums.inprise.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,a104ec5b907376c2 X-Google-Attributes: gidff5a1,public From: mike <none@notgiven.com> Subject: Re: Any ideas how to make this work? Date: 1998/10/21 Message-ID: <362DFE7C.7F70E102@notgiven.com> X-Deja-AN: 403584529 Content-Transfer-Encoding: 7bit References: <362CB185.25FCA8EF@notgiven.com> <3630d1d7.9783294@forums.inprise.com> <362CE18D.C2334D6A@notgiven.com> <3630202b.29838518@forums.inprise.com> Content-Type: text/plain; charset=us-ascii Organization: Another Netscape Collabra Server User Mime-Version: 1.0 Newsgroups: borland.public.vdbase.data.sql