I know this is an SQL question.
I am getting readings inserting into a database every 15 minutes on the
hour.
They are time stamped like so,
(dt) (columOne)
2001-02-28 12:59:59 38.7
2001-02-28 12:45:01 38.77
2001-02-28 12:30:01 38.7
2001-02-28 12:15:01 37.22
My problem is how would I do a sum value for 'columOne' adding up each
quarter for each hour?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
