Article View: borland.public.vdbase.data.sql
Article #1059Re: SQL - How to use date() function.
From: Steve Koterski
Date: Sun, 17 May 1998 00:00
Date: Sun, 17 May 1998 00:00
19 lines
1216 bytes
1216 bytes
On Sat, 16 May 1998 19:21:22 -0300, "Orlando Wlodkovski" <orlando.w@bbs2.sul.com.br> wrote: > > Local SQL, what the BDE uses for dBASE and Paradox tables, does not include a function to return the current system date. To get the current system date into an SQL statement, do one of two things: 1. Pass the date to the SQL statement as a parameter. 2. Dynamically build the SQL statement and express the date as a literal. ************************************************************************** Steve Koterski INPRISE Corporation, Technical Publications http://www.inprise.com/delphi
Technical Details
Message-ID:
<35612ece.20638549@forums.inprise.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6jl337$i4013@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,9a6a36ad618b3f1f X-Google-Attributes: gidff5a1,public From: koterski@SPICEDHAM2borland.com (Steve Koterski) Subject: Re: SQL - How to use date() function. Date: 1998/05/17 Message-ID: <35612ece.20638549@forums.inprise.com> X-Deja-AN: 353913391 Content-Transfer-Encoding: 7bit References: <6jl337$i4013@forums.borland.com> Mime-Version: 1.0 Reply-To: koterski@SPICEDHAM2borland.com Content-Type: text/plain; charset=us-ascii Organization: INPRISE Corporation, Technical Publications Newsgroups: borland.public.vdbase.data.sql