Today Problem

Article View: borland.public.interbase.sql

Article #10970

Back to borland.public.interbase.sql Previous Next

#10970

From: Joora
Date: Wed, 01 Jan 2003 20:28

5 lines
1143 bytes

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: <3e134ff4@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!diablo.theplanet.net!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,d585cf53e403a2cf,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2003-01-01 12:40:03 PST
From: "Joora" <jerzy.jerzy@wp.pl>
Newsgroups: borland.public.interbase.sql
Subject: Today Problem
Date: Wed, 1 Jan 2003 21:28:30 +0100
Lines: 8
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: <3e134ff4@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1041453044 212.2.100.246 (1 Jan 2003 12:30:44 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!diablo.theplanet.net!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail