A bit long, but it might give you some more ideas:
Select
Extract(Year from Snapshop_Date),
Extract(Month from Snapshop_Date),
Extract(Day from Snapshop_Date),
Extract(Hour from Snapshop_Date),
Extract(Minute from Snapshop_Date),
Extract(Second from Snapshop_Date),
Count...
Group By 1, 2, 3, 4, 5, 6
Mind you... this will still have a problem if the millisecond delay bridges a
second boundary, that is, it starts at the very end of a second...
So maybe like you mention, grab the 'now' into a var first, and use that might
be the best way to go...
Regards
Colin
On 19/11/2009, at 1:23 PM, Todd Martin wrote:
> Only store the date to the closest second, rather than millisecond.
>
>> Is there a way to write a query which groups together slightly differeing
>> times - the current query is
>>
>> Select Snapshot_date, Count(Table1.Snapshot_date) from Table1
>> Group by Snapshot_Date
>>
>> The problem is that the table is updated by a stored procedure which is very
>> fast, but does take a few milliseconds to run so the Group By usually
>> produces 2 or 3 lines.
>>
>> Is there either:
>> 1 - a way to query so that the group by does not care about say a 1 second
>> discrepancy?
>>
>> 2 - Or Alternatively a way to force the exact same date/time into the stored
>> procedure below - I guess it would mean
>> replacing the 'NOW' parameter below with a fixed Date/Time set at the
>> beginning of the stored procedure...
>>
>> In the stored procedure the code uses a subquery - simplified essence is as
>> below:
>>
>> BEGIN
>> FOR SELECT
>> Table2.Field1 as Param1,
>> Table3.Field2 as Param2
>> FROM Table2,Table3
>>
>> WHERE
>> ......
>> .......
>> ......
>> INTO
>> :Param1,
>> :Param2
>>
>> DO
>> BEGIN
>> Select
>> Insert into Table1
>> (Field1,
>> Field2,
>> Snapshot_date)
>> VALUES
>> (:param1,
>> :Param2,
>> 'NOW')
>> END
>>
>> SUSPEND
>>
>>
>> John
>> John Bird
>> JBCL
>> Contact:
>> [email protected]
>> 03-3844527, 027 4844528
>> http://jbclnz.googlepages.com
>> http://www.jbcl.co.nz
>> ----- Original Message -----
>> From: "PDS - John" <[email protected]>
>> To: "'NZ Borland Developers Group - Offtopic List'"
>> <[email protected]>
>> Sent: Wednesday, November 11, 2009 4:15 PM
>> Subject: Re: [DUG-Offtopic] Small favour
>>
>>
>>> Hi Peter
>>>
>>> I would be interested too what others think about this issue, so please do
>>> NOT response offlist, thanks:)
>>>
>>> This issue is similar to mine on the DUG list "Re: [DUG] HELP! : Windows7
>>> 64
>>> bits - Delphi install issues".
>>>
>>> John
>>>
>>>
>>>
>>>> -----Original Message-----
>>>> From: [email protected] [mailto:offtopic-
>>>> [email protected]] On Behalf Of Peter Hyde
>>>> Sent: Wednesday, 11 November 2009 3:40 p.m.
>>>> To: [email protected]
>>>> Subject: [DUG-Offtopic] Small favour
>>>>
>>>> Hi there,
>>>> I wonder, is anyone out there running Win7/64 bit and has time to
>>>> do a brief install/runs check for me?
>>>>
>>>> Virtual chocolate fish for the first response. Or a TurboNote+
>>>> product licence, whichever you prefer <g>.
>>>>
>>>> Please respond offlist, thanks!
>>>>
>>>> cheers,
>>>> peter
>>>>
>>>>
>>>> _______________________________________________
>>>> NZ Borland Developers Group Offtopic mailing list
>>>> Post: [email protected]
>>>> Admin: http://delphi.org.nz/mailman/listinfo/offtopic
>>>> Unsubscribe: send an email to [email protected]
>>>> with Subject: unsubscribe
>>>
>>> _______________________________________________
>>> NZ Borland Developers Group Offtopic mailing list
>>> Post: [email protected]
>>> Admin: http://delphi.org.nz/mailman/listinfo/offtopic
>>> Unsubscribe: send an email to [email protected] with
>>> Subject: unsubscribe
>>
>>
>> _______________________________________________
>> NZ Borland Developers Group Offtopic mailing list
>> Post: [email protected]
>> Admin: http://delphi.org.nz/mailman/listinfo/offtopic
>> Unsubscribe: send an email to [email protected] with
>> Subject: unsubscribe
>>
>
> _______________________________________________
> NZ Borland Developers Group Offtopic mailing list
> Post: [email protected]
> Admin: http://delphi.org.nz/mailman/listinfo/offtopic
> Unsubscribe: send an email to [email protected] with
> Subject: unsubscribe
#####################################################################################
Attention:
The information in this email and in any attachments is confidential. If you
are not
the intended recipient then please do not distribute, copy or use this
information.
Please notify us immediately by return email and then delete the message from
your
computer. Any views or opinions presented are solely those of the author.
####################################################################################
_______________________________________________
NZ Borland Developers Group Offtopic mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/offtopic
Unsubscribe: send an email to [email protected] with
Subject: unsubscribe
