Getting Count of Log Items in a given year

Ed Dressel

Delphi Developer

Sat, 20 Aug 2005 23:51:50 GMT

Getting Count of Log Items in a given year

I need to count the number of log items for a given year. My current SQL
statement is:

select count(*)
from ClientLog
where Client_Id = :ClientID;

I would like to change that so that a TimeStamp field's year value is equal
to an integer param I pass in, something like:

select count(*)
from ClientLog
where Client_Id = :ClientID
and ExtractYear(Event_DateTime) = :Year

How can I do this (without adding DLL's, which I don't have the option to
do)?

Thanks
Ed Dressel

Martijn Tonie

Delphi Developer

Sun, 21 Aug 2005 00:15:41 GMT

Re:Getting Count of Log Items in a given year

Hi Ed,

Quote

> I need to count the number of log items for a given year. My current SQL
> statement is:

> select count(*)
> from ClientLog
> where Client_Id = :ClientID;

> I would like to change that so that a TimeStamp field's year value is equal
> to an integer param I pass in, something like:

> select count(*)
> from ClientLog
> where Client_Id = :ClientID
> and ExtractYear(Event_DateTime) = :Year

> How can I do this (without adding DLL's, which I don't have the option to
> do)?

Assuming IB6 ( you didn't tell us ) - use:

EXTRACT ( YEAR FROM Event_DateTime ) = :Year

Did you read the documentation?

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Other Threads

1. TRichEdit.Lines.Count Giving Incorrect Count?

2. Give me Year of Today's Date

3. Interbase Log Files: "Defining given symbol"

4. Logged in User Count

5. Record count gives -1

6. Please help with Delphi generating a log of item deleted from db

7. Tdirectorylist box items count??

8. count items in listbox

9. count items in listbox

10. No Recipients.Items.count using TIdMessage???