Re: Dates in SQL

Article View: borland.public.vdbase.data.sql

Article #243

Back to borland.public.vdbase.data.sql Previous Next

#243

From: John Staub
Date: Wed, 13 Jan 1999 00:00

22 lines
1004 bytes

Steve,

  Thanks.  I will probably end up taking that approach.

John

--
Staub & Associates, Inc.
(850) 913-8488
http://www.staubassociates.com
Buy books, music & video online
at http://www.staubassociates.com/bkstore.htm

Steve Swanson wrote in message <77j6re$sli14@forums.borland.com>...
>John
>
>I've had good luck using parameters.
>
>q = new query()
>q.sql = 'select * from mytable.dbf where datefield  + 60 < :mdate'
>q.params["mdate"] = date()
>q.active = true

Technical Details

Message-ID: <77jesn$sm119@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <77j1h0$sll12@forums.borland.com> <77j6re$sli14@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,e21b85d41667a82e
X-Google-Attributes: gidff5a1,public
From: "John Staub" <bmds@worldnet.att.net>
Subject: Re: Dates in SQL
Date: 1999/01/13
Message-ID: <77jesn$sm119@forums.borland.com>
X-Deja-AN: 432349053
References: <77j1h0$sll12@forums.borland.com> <77j6re$sli14@forums.borland.com>
X-MIMEOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message