Re: Today Problem

Article View: borland.public.interbase.sql

Article #10972

Back to borland.public.interbase.sql Previous Next

#10972

From: Elad Keat
Date: Wed, 01 Jan 2003 21:07

20 lines
1500 bytes

Maybe try

WHERE TRAFFIC_LOG.TIMEPOINT BETWEEN 'today'-7 AND 'today'-6

This way it should look at data between 7 days ago at 00:00:00 and 6 days
ago at same time, i.e. 24 hours.

Elad


"Joora" <jerzy.jerzy@wp.pl> wrote in message
news:3e134ff4@newsgroups.borland.com...
> 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?
>
>
>

Technical Details

Message-ID: <3e135877@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!opentransit.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <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 13:09:39 PST
From: "Elad Keat" <elad@NOSPAM.COM>
Newsgroups: borland.public.interbase.sql
References: <3e134ff4@newsgroups.borland.com>
Subject: Re: Today Problem
Date: Wed, 1 Jan 2003 23:07:10 +0200
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 212.179.179.179
Message-ID: <3e135877@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1041455223 212.179.179.179 (1 Jan 2003 13:07:03 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!opentransit.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message