Article View: borland.public.vdbase.data.sql
Article #347Re: Any ideas how to make this work?
From: Romain Strieff [TeamB]
Date: Wed, 21 Oct 1998 00:00
Date: Wed, 21 Oct 1998 00:00
15 lines
1259 bytes
1259 bytes
In article <3630202b.29838518@forums.inprise.com>, Steve Koterski grudgingly admits... > 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. > That's why we use 20.10.1998 <g,d&r> -- Romain Strieff [TeamB] check this URL for all the copies of the previous electronic VdB Newsletters http://www.openenv.com/feedback/archive/VdBASE/
Technical Details
Message-ID:
<MPG.1097fde87273d94d98982f@forums.inprise.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: teamb@opto-pps.com (Romain Strieff [TeamB]) Subject: Re: Any ideas how to make this work? Date: 1998/10/21 Message-ID: <MPG.1097fde87273d94d98982f@forums.inprise.com> X-Deja-AN: 403547591 References: <362CB185.25FCA8EF@notgiven.com> <3630d1d7.9783294@forums.inprise.com> <362CE18D.C2334D6A@notgiven.com> <3630202b.29838518@forums.inprise.com> Organization: TeamB Newsgroups: borland.public.vdbase.data.sql