"lkeeton" <[EMAIL PROTECTED]> wrote:
> from here is where i need a solution that gets me the difference of these
two
> times in a decimal format. Of course once I get that I may need to convert
> back in english to say there are 30 minutes and 44 seconds.
You didn't state whether you're using a w
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();
SEL
I like to work with times as follows:
if
1 second = 1 / 86400 or 0.12
then
12 hours = 0.5
24 hours = 1.0
36 hours = 1.5
48 hours and 1 second = 2.12
and so on.
Regards,
Doug
> -Original Message-
> From: lkeeton [mailto:[EMAIL PROTECTE
"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
See the TIME_TO_SEC() function. The rest is straightforward.
--
S
