Article View: borland.public.intrabuilder.data.sql
Article #84Re: Local SQL and DATE ??
From: Bernt Wold
Date: Mon, 24 Aug 1998 00:00
Date: Mon, 24 Aug 1998 00:00
26 lines
1140 bytes
1140 bytes
Thanks..... Ken Mayer [TeamB] wrote: > Bernt Wold <bwold@online.no> wrote: > > >Is there a way to get the current date from local SQL in my quiery ?? > > > >My code is something like this... > > > >SELECT * FROM "test.db" Where test_dato > XXXXXXXXX > > > >What should I write CurrentDate() or ????? > > try: > > d = new Date(); > > select * from "test.db" where test_dato > :d > > Ken > --- > Ken Mayer [TeamB] > Golden Stag Productions > http://www.mindspring.com/~hirschv/homepage.htm > http://www.mindspring.com/~hirschv/dbase/dbase.htm
Technical Details
Message-ID:
<35E18B06.57D7503B@online.no>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<35DFFCEA.788EAB3E@online.no> <35e05801.3888651@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 101d9a,95fed6d25ef14723 X-Google-Attributes: gid101d9a,public From: Bernt Wold <bwold@online.no> Subject: Re: Local SQL and DATE ?? Date: 1998/08/24 Message-ID: <35E18B06.57D7503B@online.no> X-Deja-AN: 384220560 Content-Transfer-Encoding: 7bit References: <35DFFCEA.788EAB3E@online.no> <35e05801.3888651@forums.borland.com> Content-Type: text/plain; charset=us-ascii Organization: Another Netscape Collabra Server User Mime-Version: 1.0 Newsgroups: borland.public.intrabuilder.data.sql