RE: Subtracting Dates

2001-11-29 Thread Mark Rissmann
It would be beneficial to the group if everyone would post their solutions to the list if they solve it on their own. IMHO, Mark -Original Message- From: Ken Kinder [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:10 AM To: Walter D. Funk; [EMAIL PROTECTED] Subject: Re:

RE: Any datetime gurus out there?

2001-11-26 Thread Mark Rissmann
function which was my demise. SELECT UserId, SUM((UNIX_TIMESTAMP(LogoutDate) - UNIX_TIMESTAMP(LoginDate))) / 3600 AS secs FROM tbl_name GROUP BY UserId; Works great. Mark Rissmann At 4:21 PM -0800 11/25/01, Mark Rissmann wrote: Thanks Mr. DuBois, I must have missed a function (or banged my head

Re: Ultimate DB Server

2001-10-28 Thread Mark Rissmann
by php via the internet. The databases will be about 400mb estimated for the first year. Any recommendations or info would be greatly appreciated. (Or things NOT to do) :) Mark Rissmann Drifting Sands LLC - Original Message - From: Mike Rogers [EMAIL PROTECTED] Sent: Sunday, October 28

Re: high speed insertion required

2001-09-14 Thread Mark Rissmann
in the same server/database? The hash tables are in the same database. Well, I think maybe I should face the reality, maybe my program has already tried its best, and so have we(us? hehe, poor english :). Any way, thanks for your help. From: Mark Rissmann [EMAIL PROTECTED] To: Z Julian [EMAIL