If there's a record for each hour then wouldn't the number of hours just be
the number of records less the first one?
-----Original Message-----
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: 01 March 2001 16:16
To: CF-Talk
Subject: date times
If there is anything I struggle with its dates and times:
What I'm trying to do is this.
Select a time from in my database.
SELECT DT, sessionStatus
FROM dbo.milford
WHERE SESSIONSTATUS = 1
SELECT DT, sessionStatus
FROM dbo.milford
WHERE SESSIONSTATUS = 0
There is a timestamp for every hour between start time and finish time.
a session will last for 24 hours at least, maximum 7 days.
We are timing a pump here.
Now how would I add up the hours here, any ideas would be appreciated??
Many thanx advance......
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
