RE: number of transactions

Gentsch, Sam said: > You are SOOOO evil. Awww, shucks, you're making me blush. > -----Original Message----- > On Behalf Of Obnoxio The Chav > > __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