Agreed - haven't figured out how to do that yet - any hints? (I am reading the help on the Extract command, which looks promising but not sure if it applies to stored procedures - and if it can be done in a sub-query. This is at the limits of my knowledge of what stored procedures can do, hence the question!)
John Bird ----- Original Message ----- From: "Todd Martin" <[email protected]> To: "NZ Borland Developers Group - Offtopic List" <[email protected]> Sent: Thursday, November 19, 2009 1:23 PM Subject: Re: [DUG-Offtopic] Firebird SQL question > 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 _______________________________________________ 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
