Re: [Q] date-time substraction for hours

Saqib, Judging by your example, I think you should be more concerned about whether or not there are a lot of dead people visiting your site. Or could it be that all dead souls are wandering in and out of cyberspace ? What is this site that famous dead people go to visit ? Who else have you got in there ? So many questions ! But the answer to your question depends greatly on the field type date_time_in and what a man hour is. Say Hello to Elvis for me. Tom Hogarty <Standard Disclaimer Applies> Pyramid Technology Corp (Apologies Saqib, I get giddy after too many 20 working days) > Subject: [Q] date-time substraction for hours > I need to know if there is a way to do the following in SQL. > > I have a historical database for visitors. Every time an entry is made to the system, > the following fields are inserted into my Hist_visitors table, > lname, fname, vendor, date_time_in, status > Lennon, John, Beatles, 1996-03-01 10:41 PM, IN > and on exiting the site > Lennon, John, Beatles, 1996-03-02 2:30 AM, OUT > > My question is for finding out the number of man hours spend by visitors inside our > site - for every day, allowing for repeat visitors. I have a couple of ideas but > nothing concrete. If someone has done anything like this before I would love to hear > their suggestions. > > > > -- > Saqib Mausoof > -------------------------------------------------------------------- > I have a hard enough time speaking for myself, so speaking on behalf > of my employer is out of the question. >-- End of excerpt from Saqib Mausoof