Mailing List Archive


Back to the month index Back to the list index
Thomas Greig (Thomas.Greig@himolde.no)
Mon, 28 Apr 1997 12:38:46 +0200 (MET DST) 

Date: Mon, 28 Apr 1997 12:38:46 +0200 (MET DST)
From: Thomas Greig <Thomas.Greig@himolde.no>
Subject: [mSQL] average(char)
Message-Id: <Pine.ULT.3.91.970428123247.13252A-100000@ulke>

i'm using Unix 10.01, and MSQL 2.b6.
my problem is as followes:

CREATE TABLE problem_table (
 .
 timeofReport char(35),
 .
 .
 .
)\g

 $time = timeofReport();
 $message = strftime("%H:%M, %e %b", $time);
 $time=$message;

//
time.html:

$query = "insert into problem_table time..
 + + +

My problem is to get the average time from when a problem is beeing
reported until it is treated. Both variables is defined as char(35), i've
tried to convert the char into integer and subtract or average(time), but
it don't work.

is there anyone who has had the same problem?
thanx, thomas greig, norway

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!