Re: Today Problem

Article View: borland.public.interbase.sql

Article #10974

Back to borland.public.interbase.sql Previous Next

#10974

From: Joora
Date: Wed, 01 Jan 2003 21:37

30 lines
1743 bytes

unfortunetly it doesn't support BETWEEN & TODAY & TODAY...



U�ytkownik "Elad Keat" <elad@NOSPAM.COM> napisa� w wiadomo�ci
news:3e135877@newsgroups.borland.com...
> 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: <3e135f94@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3e134ff4@newsgroups.borland.com> <3e135877@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 114a0e,d585cf53e403a2cf
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2003-01-01 13:38:54 PST
From: "Joora" <jerzy.jerzy@wp.pl>
Newsgroups: borland.public.interbase.sql
References: <3e134ff4@newsgroups.borland.com> <3e135877@newsgroups.borland.com>
Subject: Re: Today Problem
Date: Wed, 1 Jan 2003 22:37:19 +0100
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 212.2.100.246
Message-ID: <3e135f94@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1041457044 212.2.100.246 (1 Jan 2003 13:37:24 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message