Steve Werby wrote: > > "lkeeton" <[EMAIL PROTECTED]> wrote: > > I need a way in sql or simple programming to take a timpestamp(end time) > and a > > timestamp(beginning time) > > > > for instance 12:00:00 is the end time > > 11:30:44 is the start time > set @start = curtime(); SELECT somestuff FROM sometable set @end = curtime(); set @elapsed = TIME_TO_SEC(@end) - TIME_TO_SEC(@start); select @start, @end, @elapsed; Van -- ========================================================================= Linux rocks!!! http://www.dedserius.com ========================================================================= --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
