Article View: borland.public.vdbase.data.sql
Article #908Re: Sysdate
From: Steve Koterski
Date: Mon, 29 Jun 1998 00:00
Date: Mon, 29 Jun 1998 00:00
24 lines
1591 bytes
1591 bytes
On Mon, 29 Jun 1998 08:00:06 -0500, Cathy <abunlc@ccp.com> wrote: >The sql premium says Sysdate returns the system date and >time. Is Sysdate included in the dBase 7.01 implementation >of sql? Local SQL (what the BDE uses for dBASE and Paradox tables) is a subset of the SQL-92 specification for the SQL language. While SQL-92 includes a number of functions related to the system date and time (such as CURRENT_DATE and CURRENT_TIMESTAMP), the local SQL subset does not include any of these. As a result, to get the system date or time into a local SQL statement, you must either: 1. Pass the date or time to the SQL statement as a parameter. 2. Or, build the SQL statement dynamically and express the date or time as a literal. ////////////////////////////////////////////////////////////////////////// Steve Koterski "Knowledge comes, but wisdom lingers." Technical Publications -- Alfred, Lord Tennyson (1809-1914) INPRISE Corporation http://www.inprise.com/delphi
Technical Details
Message-ID:
<35a3dd39.10242678@forums.inprise.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<35978FD6.EDFA2A80@ccp.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,88d58b98c6220928 X-Google-Attributes: gidff5a1,public From: koterski@borland.com (Steve Koterski) Subject: Re: Sysdate Date: 1998/06/29 Message-ID: <35a3dd39.10242678@forums.inprise.com> X-Deja-AN: 367173389 Content-Transfer-Encoding: 7bit References: <35978FD6.EDFA2A80@ccp.com> Content-Type: text/plain; charset=us-ascii Organization: INPRISE Corporation, Technical Publications Mime-Version: 1.0 Reply-To: koterski@borland.com Newsgroups: borland.public.vdbase.data.sql