🚀 go-pugleaf

Steve,

  Thanks!!  I didn't think there was a way, but I am still _very much
learning SQL.  One of my books mentioned an Add_Months statement, but that
bombed.  I will probably go the parameter route.

John

--
Staub & Associates, Inc.
(850) 913-8488
http://www.staubassociates.com
Buy books, music & video online
at http://www.staubassociates.com/bkstore.htm
Steve Koterski wrote in message <369d26f8.1459659@forums.inprise.com>...
>On Wed, 13 Jan 1999 15:00:56 -0600, "John Staub"
><bmds@send_me_nothing_worldnet.att.net> wrote:
>
>[...]
>
>>There is a date field in the table (crtmld is the field) that I would like
>>to test.  Basically I want to know if (crtmld + 60 < date()) and if so,
>>include it.  I understand SQL does not support the date() function, but
does
>>anyone know of an equivalent in SQL?  I've tried a variety of approaches
to
>>no avail.
>
>No. Local SQL does not include a function (like CURRENT_DATE in SQL-92)
>that returns the system date to an SQL statement. You would need to either:
>
>1. Build the SQL statement dynamically and express the date as a literal.
>2. Pass the date to the statement using a parameter.
>
>//////////////////////////////////////////////////////////////////////////
>Steve Koterski                      "I do most of my writing sitting down.
>Technical Publications              That's where I shine."
>INPRISE Corporation                         -- Robert Benchley (1889-1945)
>http://www.inprise.com/delphi