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
