🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.intrabuilder.data.sql
Article #83

Re: Local SQL and DATE ??

#83
From: Ken Mayer [TeamB]
Date: Sun, 23 Aug 1998 00:00
22 lines
963 bytes
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: <35e05801.3888651@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <35DFFCEA.788EAB3E@online.no>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,95fed6d25ef14723
X-Google-Attributes: gid101d9a,public
From: supportInfo@borland.com (Ken Mayer [TeamB])
Subject: Re: Local SQL and DATE  ??
Date: 1998/08/23
Message-ID: <35e05801.3888651@forums.borland.com>
X-Deja-AN: 383946712
References: <35DFFCEA.788EAB3E@online.no>
Organization: Golden Stag Productions
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.intrabuilder.data.sql