Article View: borland.public.interbase.sql
Article #10978Re: Today Problem
From: Clinton L. Warren
Date: Wed, 01 Jan 2003 23:43
Date: Wed, 01 Jan 2003 23:43
12 lines
1445 bytes
1445 bytes
Joora wrote: > Hi, how can I query DB to recall records for seven day ago ? I was trying: > WHERE TRAFFIC_LOG.TIMEPOINT = 'today'-7 > but it shows only data with 00h:00m:00s time and I need all records from > whole > 24h.... any sugestions? Does the following do what you'd like? select * from traffic_log where timepoint between (current_date - 6) and (current_date - 7)
Technical Details
Message-ID:
<3e137d61@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3e134ff4@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 114a0e,d585cf53e403a2cf X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2003-01-01 16:12:43 PST Date: Wed, 01 Jan 2003 18:43:12 -0500 From: "Clinton L. Warren" <justdoro@attbi.com> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3a) Gecko/20021212 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: borland.public.interbase.sql Subject: Re: Today Problem References: <3e134ff4@newsgroups.borland.com> In-Reply-To: <3e134ff4@newsgroups.borland.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 12.245.211.122 Message-ID: <3e137d61@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1041464673 12.245.211.122 (1 Jan 2003 15:44:33 -0800) Lines: 13 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail