Re: SQL Help

Article View: borland.public.interbase.sql

Article #780

Back to borland.public.interbase.sql Previous Next

#780

From: Bill Todd
Date: Thu, 12 Jul 2007 23:35

9 lines
1388 bytes

You are not grouping by the date. You are grouping by the date and time
assuming that START_DATETIME is a TIMESTAMP field. Also you claim that
the table contains a column named START_DATETIME but your SELECT refers
to a field named START_DATE and you claim the SQL runs. How is that
possible? It would really help if you would show us the actual fields
with their data types and and an SQL statement that actually runs.

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <4696baa7$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <46969c24@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,8f88f6177bf0b125
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: SQL Help
Newsgroups: borland.public.interbase.sql
References:  <46969c24@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <4696baa7$1@newsgroups.borland.com>
Date: 12 Jul 2007 16:35:03 -0700
X-Trace: newsgroups.borland.com 1184283303 216.207.211.19 (12 Jul 2007 16:35:03 -0700)
Lines: 9
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message