"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
[EMAIL PROTECTED]]
> Sent: Friday, April 06, 2001 13:29
> To: [EMAIL PROTECTED]
> Subject: Does anybody know the formula to convert difference
> of time in
> decimal
>
>
> I am working on a project that needs to get
>
> This particular format 1000.25
>
> 1000 r
"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
I am working on a project that needs to get
This particular format 1000.25
1000 representing hours and 25 represent minutes
1000 means a full 1000 minutes
.25 means a quarter of an hour
so essentially in english language we could say a thousand hours and about 15
minutes
I need a way in sql
