RE: number of transactions
You are SOOOO evil.
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Obnoxio The Chav
Sent: Wednesday, January 19, 2005 1:19 PM
To: __toto
Cc: informix-list@iiug.org
Subject: Re: number of transactions
__toto said:
> hi,
> how can i know the number of transactions on a database in a given
> period (for example 1 day) ???
select count(*) from systranlog where tran_time_stamp between "2005-01-10 00:00:00.000" and "2005-01-10 23:59:59.999";
The population of the systranlog table is left as an exercise for the reader.
--
Bye now,
Obnoxio
"C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule"
- Coluche
"I'm trying to see things your way, but I can't get my head up my ass"
- JCH
"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco
If anyone told you to be yourself they would be giving you bad advice.
I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school.
-- Ahmed Ahmed
sending to informix-list
sending to informix-list